Looking For Formula To Look Up Contents Of One Cell

Morning All

To be frank I am pretty useless, at working out formulas, so am looking for some help please.

With the attached file, I am trying to create a simple accounts spreadsheet, and have created three sheets within that file. Sheet 1 is the contents of my stock, Sheet 2 are my sales and Sheet 3 are my purchases.

What I would dearly like is a formula to be entered in D2 sheet 2, that looks up C2 on sheet 2 from B column on sheet 1 and returns the value of the result from column D on sheet 1.

And then on Sheet 2 another formula to be entered in E2 that looks up C2 on sheet 1 in the B column and multiplies it by the amount entered in B2 Sheet 2.

And for it to be possible to copy the formulas down in blank cells that will look up and return different results if I enter different items in Column C Sheet 2.

I hope that makes sense and sorry for any confusion.

Thank you so much.

Steve

Hiya

many many thanks for that, I think on the second formula I made a mistake in explaining myself

And then on Sheet 2 another formula to be entered in E2 that looks up C2 on sheet 1 in the B column and multiplies Sheet 1 H2 it by the amount entered in B2 Sheet 2.

Thanks I forgot to add the bit highlighted in red.

Thanks ever so much

Steve

Hi All

No the above formula isnt correct, sorry about that.

What I would like it to do is to calculate on sheet 2 in cell E2, to look up C2 on sheet 2 on sheet 1 in the B column and then multiplies sheet 1 cell H2 by sheet 2 B2.

Many thanks everyone hope I have explained myself better this time.

Regards

Steve

Hiya All once again.........

Sorry to be a nuisance, but am desperate to get a formula sorted.

On the attached file I have created 3 sheets (stock, sales and purchases) What I would like it to do is to calculate on sheet 2 in cell E2, to look up C2 on sheet 2 on sheet 1 in the B column and then multiply sheet 1 cell H2 by sheet 2 B2.

Hope that makes sense and thanks in advance.

Steve

Thanks for that Trevor, yes you're right I have made it confusing, here goes then :-

Sales Sheet in first cell under Price sold, to find item on Sales Sheet in corresponding cell under Item Column in Stock Sheet Column B Item and then multiply it by corresponding cell on stock sheet under Retail Selling Price with the number sold on sales sheet in the Sold Column

really hope that explains it better

Steve