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?
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?
Peace of mind is found in some of the strangest places.
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))
Regards,
Simon
Please read this before cross posting!
In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
If I have seen further it is by standing on the shoulders of giants.
Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)
That might work.
Peace of mind is found in some of the strangest places.