Excel LOOKUP Programming

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

myrc60

Thread Starter
Joined
Nov 20, 2002
Messages
143
I have two spreadsheets; the first has two columns, UPC and ITEM; the second has many columns of which UPC is one. I need to create a lookup function or something that will insert the value of ITEM from the first spreadshet into a new column I will create in the second spreadsheet based on the UPC matching. I prefer to use Access for these situations but I don't want to do that with this data. Is this easy to do?
 
Joined
Jul 1, 2005
Messages
8,546
Yes. Give me 5 minutes & I'll post a formula. Or does it have to be "programming"?
 
Joined
Jul 1, 2005
Messages
8,546
If (on Sheet1) A is the UPC column and B is the Item column, then on Sheet2 use:

=INDEX(Sheet1!B:B,MATCH(A2,Sheet1!A:A,0))

(where UPC to be looked up is in Sheet2!A2).
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Members online

Top