Vlookup on another sheet

[Aussiebear]

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")

[Aflatoon]

(be aware I have already "sampled the brew")

That explains it. ;)

The lookup value 2015-4-001 isn't in your table. (2015-5-001 is, though)

[Aussiebear]

:omg2:Thank you.

[SamT]

AussieBear,

I edited this line in the BeforeDoubleclick code


If Not Intersect(Target, Sheets("Work Orders").Range("A:A")) Is Nothing Then

And this one in the NewJobNumer


If Not Cel.End(xlDown).Row = Rows.Count Then Exit Sub
If Cel <> "" Then Exit Sub

[Aussiebear]

Thanks Sam