LOOKUP FORMULA

L

Lindsay

Okay I have two seperate sheets. Ineed a formula that will look at the item
number in both sheets and return a valua from one to the other for the same
item number. Make sense. I am trying to reference the price from one list
to another list without manually entering them because both sheets do not
contain exactly the same item numbers. Thanks
 
P

Pete_UK

Assume Item Numbers are in column A on both sheets, and Prices in
column B, and that you have a header row on both sheets so that the
data starts in row2. Assume you want to bring data from Sheet1 into
Sheet2. Enter this formula into B2 of Sheet2:

=VLOOKUP(A2,Sheet1!A$2:B$500,2,0)

This is set up for 500 rows of data in Sheet1 - adjust to suit, then
copy the formula down column B for as many items as you have in column
A.

Hope this helps.

Pete
 
L

Lindsay

Okay that did not work. Let me give the details

Sheet one has item numbers listed in column B
Sheet two has item numbers listed in column B and their price in column G

I need the items from sheet one to automatically reference the correlating
price from sheet 2 column G into sheet 1 column G

Think you can help
 
Top