Please help me figuire this out ive been to vlookup site by mr. ritchie. no luck

[Erik]

6-10 11-15 16+ 6-10 11-15 16+
LH 750 1125 1500 60 90 120
OH1 1000 1500 2000 90 120 150
OH2 1500 2250 3000 90 120 150
EH1 2500 3750 5000 150 195 240




WATER REQUIRED 1500 GPM @ cell C4 PSI

Im trying to make a Formula that staes if cell (1) has
one of the 4 letters on the right side of the table and
cell (2) has a number that corresponds with top line of
the table (ex..6-10..11-15...16+) then insert figuire
thats located in the table cell into cell (3).. this is
what i have for a formula put its not working.. its only
taking the last figuire and inserting it cell (3)

=IF(ISERROR(VLOOKUP($C$4,$E$21:$H$24,4,0)),"cell L4",
VLOOKUP($C$4,$E$21:$H$24,4,0))

 

[JE McGimpsey]

If I understand you correctly, here's one way:

Assume Cell (1) = A1, Cell(2) = B1 and Cell(3) = C1. Assume also that
the table is in J15 (note that this will not work if your headers in
row 1 are duplicates, as your example shows):

=IF(ISNA(MATCH(A1,J1:J5,FALSE)), "", IF(ISNA(MATCH(B1,J11,FALSE)),
"", VLOOKUP(A1,J15,MATCH(B1,J11,FALSE),FALSE)))

 

[Guest]

Thanks i tried it out.. but still didnt work.. so now im
trying this a different way.. i split the table up..
Table 1 Table 2
6-10 11-15 16+ 6-10 11-15 16+
LH 750 1125 1500 LH 60 90 120
OH1 1000 1500 2000 OH1 90 120 150
OH2 1500 2250 3000 OH2 90 120 150
EH1 2500 3750 5000 EH1 150 195 240


What i need it to do is for cell(x) to look at cell (1)
for a code. Then look at Cell (Y) for a number. Then i
need the number in that axis entered into cell (x)

Example from table 1..

Cell (1) has OH1.....Cell (Y) has the number 14

Cell (x) will have 1500 inserted into it

thanks for the help guys