VLOOKUP returning #N/A error

[PaulMelloy]

Hi there

Can someone have a look at the attached excel sheet for me and let me know what I am doing wrong with the VLOOKUP formula ?

I am trying to use the data held on the "Numbers" worksheet to automatically populate the "Time Record" details when I enter the Corresponding Job Number into cell I11, but I can not seem to get it to do this.

The data on the "Numbers" sheet is entered using a Form, so is set up as a table.

Any help would be GREATLY appreciated.

[jomaor1]

Hi!

Try changing inside the formula, the "B" to an "A", like this:

=VLOOKUP($I$11,Numbers!$B$2:$I$2501,2,FALSE)

to =>

=VLOOKUP($I$11,Numbers!$A$2:$I$2501,2,FALSE)

Cheers!

[Glenn Kennedy]

Hi. Your thread title is far too vague. It should resemble the sort of thing you would use if searching for a solution in Google.

As you're new, I've done it for you. However, you can expect to have your threads locked in future, until you make such changes YOURSELF.

[Glenn Kennedy]

Incidentally, VLOOKUP is quite happy with whole column ranges, so this might be easier to maintain:

=VLOOKUP($I$11,Numbers!$A:$B,2,FALSE)

[PaulMelloy]

That is perfect - thank you so much

[Glenn Kennedy]

Dunno who you're talking to (you didn't say), but glad you got sorted!!

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.