I want a Vlookup function that looks for a range of items in another
worksheet and if yes returns the part number and cost. See attached
file

For example Worksheet AC-P & HP-P are the target sheets. Looking at
worksheet AC-P cell A9 if the cell contents of A9 is CKL18-1* then a
function in I9 LOOKS AT worksheet PRODUCTS for a CKL18-1* and writes
the items prod number in that cell A9. I'd also like it to do the same
for the ARUF018-00*-1* that is in the next column and so on.


+-------------------------------------------------------------------+
|Filename: GOODMAN.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4393 |
+-------------------------------------------------------------------+

--
nander
------------------------------------------------------------------------
nander's Profile: http://www.excelforum.com/member.php...fo&userid=6156
View this thread: http://www.excelforum.com/showthread...hreadid=515764