VLookup

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
I am sure this can be done with formula's, but it might be worth it to look
into using SQL on sheet ranges.
If you want to give this a try look at the post in this NG on 2 December
2005:
Count duplicates in an array.

RBS
 
Thanks for your help, I think I found the solution to my problem in the
"Vlookup & Offset" post from 12/1.
 
Back
Top