I am not quite getting your question. Can you explain more?

By the way, VLOOKUP table must be sorted in order for VLOOKUP() to
function properly.


Phillycheese5 Wrote:
Yes, that does work (thanks)...However, I have cases where I want to put
non-consecutive results together. The VLOOKUP is referencing a table
that is in order, but this is not always the case and it's too
complicated to rearrange the table which itself is made up of
formulas.
Is there a way to use the IF function to do something if a specific
range (i.e. 5-9) or set of numbers (1,7,12,23) is the result?


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=390638