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

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

Lindsay wrote:
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

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

"Pete_UK" wrote:

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

Lindsay wrote:
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