Aussiebear
05-20-2015, 03:09 AM
I'm increasingly frustrated with Excel for Mac 2011 issues..... Latest is, trying to lookup a table on another sheet. I have named a dynamic table as Jobs, on Sheet 'Work Orders" which currently houses data in A2:E7. From Sheet "Operating" in Column C I am trying to link the Job number in Column B and find the task description from the table "Jobs"
Hence I tried to use =Vlookup($B2,Jobs,5,0) but the result is #N/A, whereas I was expecting "Clean & Stack timber".
Can someone point out the error of my ways before I drink my self to oblivion..... (be aware I have already "sampled the brew")
Hence I tried to use =Vlookup($B2,Jobs,5,0) but the result is #N/A, whereas I was expecting "Clean & Stack timber".
Can someone point out the error of my ways before I drink my self to oblivion..... (be aware I have already "sampled the brew")