Solved: VLOOKUP Question

[austenr]

I have a VLOOKUP that I need to just use the top row of if a person is over a certain age. The VLOOKUP I currently use is a named range. Would I be just as well of creating another named range of just that one row and using that?

[Simon Lloyd]

Do you mean something like this?
=IF(VLOOKUP(A1,A2:F20,1,FALSE)>26,VLOOKUP(A1,A2:F20,2,FALSE),VLOOKUP(A1,A2:F2,3,FALSE))

[austenr]

That might work.