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


"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!

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


"DA@PD" wrote:

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!