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?


--
Phillycheese5
------------------------------------------------------------------------
Phillycheese5's Profile: http://www.excelforum.com/member.php...o&userid=24196
View this thread: http://www.excelforum.com/showthread...hreadid=390638