If formula that is dependent on another sheet for several values

[CindyZee]

I'm sorry if the following description doesn't use the correct terminology. I'm a novice trying to make a spreadsheet to help with my business.

On page two I have purchases listed by number (purchase #1, purchase #2, etc) and it includes a column that lists the average cost per item from that particular purchase.

On page one I want it to look at the purchase number, and then auto populate the average cost per item into a cell on that page taking it from page two.

So for instance, if it says it's purchase #2 on page one, I want it to go to page two and pull the average cost per item for purchase #2, and place it into cell. If it says purchase #3, then I want it to put the average cost per item from purchase #3, etc.

If E = A5, I5

E= Purchase # on page 1
A5= Purchase # on page 2
I5 = Average cost per item from page 2

But I need it to check for A5-A500, and enter the corresponding value for I5-I5000

Hopefully someone can help! Thank you!

[mrshl9898]

I'm not certain I am following you exactly, uploading a file with what you have and what you are after helps alot.

sounds like you need a VLOOKUP

=VLOOKUP(A1,Sheet2!A:B,2,0)

where A1 is the location of the purchase order number, and Sheet2!A:B has the purchase order in column A and the Average price in Column B.

[CindyZee]

Oh my goodness, it worked! Thank you so much!