Hi Experts,
In Sheet 3 of my workbook I'm using an
=IF(ISNA(VLOOKUP('Sheet2'!B2,'Sheet1'!E2:E40770,1, FALSE)),"",VLOOKUP('Sheet2'!B2,'Sheet1'!E2:E40770, 1,FALSE)))
command to return matching part numbers of a small list in column B of Sheet2
from a large list of 40,000 part numbers in Column E of Sheet 1. this is
simple enough, but what I'd like to be able to do is also list values such as
warehouse# (Column A, Sheet 1) and the stock code (Column B, Sheet 2) for the
part that would be on the same row on Sheet 1. How can I write a command
that when there is a vlookup match of the part number, it returns values of
other columns from the same row aswell???
Thanks!