Calculate / vlookup

[chally3]

If, vlookup calculation?

Hi everyone,

I'm trying to streamline a process where we compare the difference in prices (annually) on a spreadsheet without copying all the data onto 1 worksheet.

We have a data extract (Columns A:L) with 2 work sheets in the extract (labelled current and last year).


What I wish to do is Vlookup the item shown in column A on worksheet "current" and look at its cost in column C (same worksheet) and then find the difference using the same critera on worksheet "last year" ie find the difference between the 2 costs.


Thank you

 

[steve the fish]

Try this:

=C1-VLOOKUP(A1,'last year'!A:C,3,0)

 

[djmixer135]

Hi,

Try

='CURRENT PRICE' - VLOOKUP('ITEM NAME', 'LOOKUP TABLE', 'COLUMN NUMBER FOR LAST YEAR', 0)

 

[chally3]

Thank you both, that's one I will remember forever. Much appreciated

 

[djmixer135]

You're more than welcome