Thread: VLookup
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
 
Posts: 2,452
Default VLookup

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


"DA@PD" wrote in message
...
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!