Not really, since there are amny categories, I would have to change the
filter each time, if I want to see all the categories, I am trying to see if
this can be made easier ain a VLOOKUP format.

"gjcase" wrote:


Why not just filter the original list? An autofilter on Category would
get you what you're after, wouldn't it?

---GJC


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=529214