Hi guys,
I have employee names and two sets of values.
I want a vlookup and or way to return the difference in column B and Column D to return the values. The names in column A will be in different order....
I.e. In cell C2 on my march and feb tabs, I want a formula to show what is the difference between cell b2 in march and cell b2 in feb for the name in cell A2
In cell d2 on my march and feb tabs, I want a formula to show what is the difference between cell d2 in march and cell d2 in feb for the name in cell A2
Can anyone help please?
I am trying this in cell C2: =VLOOKUP($A2,Feb!A:D,2,FALSE)-B2 (ON THE MARCH TAb). IS this the best way? it would be good to show the positive and negative numbers..
Bookmarks