Help with Match function

[nander]

Need just a bit more help here, if you would please. In the attached
file the CUST worksheet has a column PRICE.POINT AND CO#. I'd like the
PRICE.POINT AND CO# corresponding data from the worksheet POINTER to
appear in the CUST worksheet by matching the CUST number in the CUST
worksheet with the CUST number in the POINTER worksheet. I had to
reduce the number of customer in the file to upload to this forum.
there may be a chance the customers listed might not have a
corresponding customer in the pointer worksheet.


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

 

[Bryan Hessey]

I would use:

=IF(ISNA(VLOOKUP(E2,POINTER!A$2:E$999,4,TRUE)),"Missing
Customer",VLOOKUP(E2,POINTER!A$2:E$999,4,TRUE))

and

=IF(ISNA(VLOOKUP(E2,POINTER!A$2:E$999,5,TRUE)),"Missing
Customer",VLOOKUP(E2,POINTER!A$2:E$999,5,TRUE))

--