Multiple lookup values

[ECLOUTIER]

I need a formula that will lookup a value, if found return the answer, if not found look up the next value, if found return the answer, if not found look up the next value and return the answer.

look up data
100 200 300

table

1001 56
1002 59
200 60
450 58

Formula would check 100 first, not find it and then check to 200 find it and return the value 60

 

[NeonRedSharpie]

=IFERROR(VLOOKUP($A$1,$F:$G,2,0),IFERROR(VLOOKUP($B$1,$F:$G,2,0),IFERROR(VLOOKUP($C$1,$F:$G,2,0),"Not Found")))

This assumes look up values in A1, B1, C1 and your table in F:G.

 

[Aladin Akyurek]

Let A2:B5 house the table and D2:F2 the three lookup values.

G2:

=INDEX(B2:B5,LOOKUP(9.99999999999999E+307,MATCH(D2:F2,A2:A5,0)))

which returns the correlate of the last successful match.

 

[ECLOUTIER]

The IERROR string worked perfectly. I was way over thinking; so simple!

 

[Aladin Akyurek]

Have you evaluated the proposal of post #3, with or without IFERROR?