I'm having a problem with a Vlookup and it's driving me nuts - it's probably something really simple that I've become blind to and missed (I've done about 100 different ones in different workbooks in the past day so getting a bit fed up with them!)
The worksheet is attached.
In sheet "Data Entry", a value is entered in cell J3 and the command button pressed.
This populates cells J17 - J18 with values. The adjacent cells to these are vlookups which refer to the corresponding J column. It is supposed to return the values in the second column of sheet "current actual values", but all I'm getting is either #Ref or #NA and I can't for the life of me work out why.
Can anyone have a quick look and put me out of my misery?
Bookmarks