Lookup Macro?

  • Thread starter Thread starter mr-pj
  • Start date Start date
M

mr-pj

Can anyone help with this function.

I have a worksheet with 12 columns. This is my master worksheet (1).
Column A represents a product SKU, the other fields, relate
infomation.

I have another worksheet (2) with one column. This represents produc
SKU numbers that I need to highlight on worksheet 1.

The final should be a new worksheet with all of the SKUs fro
Worksheet(2 )with the pertinent info.

Or the original Worksheet (1) with the rows highlighted.

Sorry if this is confusing. I am just occasional Excel user.

Thanks
Paul Perr
 
if you're only looking to bring back specific column(s) of data
something like...

=vlookup($a1,Sheet1!$a1:$L100,12,0)

change the ... 12 ... to whatever column number of info you wish t
bring back.
change the ... 0 ... to 1 or leave blank to go to a <= (less than o
equal to) match.

HT
 
Thanks firefytr for your quick response!

I need to return all the fields.
The list is about 1000 records and the original worksheet has ove
10000.

Just to give you a better idea of what I have to achieve:

From a suppliers list of 10,000 books (Worksheet 1)
I have to extract 1000 of the most popular titles (worksheet 2)

The final result is a worksheet with the 1000 titles and 11 columns o
related data.

Thanks,
Pau

Attachment filename: book2.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=48154
 
well, how do you want to extract the 1,000 records from the 10,000? yo
didn't specify any criteria, or even how you wanted to go about tha
one.

now, if the data was already extracted, or you knew what you wanted -
say you had those selections in a1:a1000 of Sheet2.

for an easy formula (no customizing - i hate customizing! i'm
copy/fill kinda guy) something like this ...

in B1 enter:
=vlookup($A1,Sheet2!$A$1:$L$1000,column(),0)

fill accross to L1, then with selection A1:L1, fill down to row 1000.

i hope this is what you are looking for. if you don't already, an
need a way to sort your data for your unique records, post back wit
exactly what you need and you you need to get there.

ht
 
The data in Book2.xls Column "A" are the items I want to extract fro
book1.xls

I guess it has to compare the data Column "a1-a100" and find sam
number in book1,column "a1:a200" then I should end up with all data fo
the 100 items.

I need everything in book2.xls

Feel free to call me at 800-592-7662
I deal in computer books and would be glad to work out a trade.
I may have so other small projects like this one.

Thanks
Pau
 
okay, if the data is in book 2, sheet 1, try the following ...

=vlookup($A1,[book2.xls]Sheet1!$A$1:$L$1000,column(),0)

... if this doesn't work, pm (private message) me with your email, o
let me know to just call you or something.

hope this helps you
 
Back
Top