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 |
+-------------------------------------------------------------------+

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

I would use:

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

and

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

--

nander Wrote:
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.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=530227