Comparing two Excel Fields (matching)
Posted on 2013-05-13
I am doing a small excel project for a HOTEL. This is simpler that it sounds. Look at the sheet.
The manager wants to know what his projected ROOM sales are for the coming months.
Eg. See attached where
the projected sales for August are 41 as at May 1st
the projected sales for August are 45 as at May 8th
NOTE : For reasons I will NOT go into, the months will be displayed in RANDOM sequences on the sheet.
WHAT I WANT!
See yellow highlights on sheet - headed "Difference".
I want a formula in column "K" which takes the month in Column "F" (August, value 45) and subtracts the corresponding value in Column "B". (e.g. 45-41=4)
(I have tried VLookup to no avail).