Hlookup

[fennell_n]

I wish to return a value from the bottom row of a four row(x 70 column)lookup table
If some value's are duplicated in the top row of the table how do I use the value in the second row as the selection criterium. If the second row value's are unable to make the difference I wish to use the value in the third row.

[Mark W.]

Why don't you insert a row before your existing 4th row that concatenates the 1st three rows and match your lookup_value against it! For example, if A1:D4 contains...

{1,1,2,3
;1,3,3,7
;1,2,3,4
;"A","B","C","D"}

Insert a new 4th row so that A1:D5 contains...

{1,1,2,3
;1,3,3,7
;1,2,3,4
;"111","132","233","374"
;"A","B","C","D"}

...and then use =HLOOKUP("132",A4:D5,2,0) to return "B".