I created a macro that copies and pastes the 3 COLs from my equipmen
list (the ones I needed) into a new sheet(3), and ran the lookup off o
that. The lookup was modified as follows:

LINE ITEM
=IF(E8<"",VLOOKUP(E8,Sheet3!A:B,2,FALSE),"")

QUANTITY
=IF(E8<"",VLOOKUP(E8,Sheet3!A:C,3,FALSE),"")


PS: I never knew there was a VLOOKUP wizard in excel. I've got over
years experience on excel. DUHHHHHH

--
Message posted from http://www.ExcelForum.com