Excel 2007 : Help needed to create a lookup

[jaybeethebeefy]

Hi all, first post on this forum.

I have a spreadsheet with two sheets, where the first sheet has a column (Product Profit) that relies on a cell in sheet 1-1 for a value as follows:

=((I2-G2*'Sheet 1-1 - Table 1'!C2))

On Sheet 1-1, Column B and C are Product and Cost respectively, sample data:

Product Cost
Aciclov 1.45

How would I create a lookup, to replace the above formula referring to C2, that does a lookup on the E column on Sheet 1, matches it with the Product column (B) on Sheet 1-1 and uses the corresponding value in the Cost column (C). I would like ALL formulae in the column to follow the same format (which I hope they will if we copy formats)

Many thanks,

Jaybee.

[NBVC]

Perhaps?

=I2-G2*VLOOKUP(E2,'Sheet 1-1 - Table 1'!B:C,2,FALSE)

[jaybeethebeefy]

Fraid not, that just shows the value 'True'.

[NBVC]

That should look up the value found in E2 of your current sheet, find it in column B of the lookup sheet and return what is in column C of the same row where the match was found.

It then should multiply by the G2 value, and subtract that result from I2.

Not sure how it gets you "TRUE" result?

[jaybeethebeefy]

Much appreciate the efffort, but the boss has already solved the issue. Don't know how!!

Cheers,

Jaybee