Vlook up N/A error

[davidingilbert]

Hello all -
I am attempting to do a Vlookup that has a list box thrown into the mix.

What is happening is inside the list box, there are a group of dates. When I click on a set of dates, a numbers appears in Cell B10 corresponding to how far down from the top I am.

What I am attempting to do is set up a vlookup where the formula inside cell C10 looks at B10, goes to another tab on the spreadsheet called "Date List", looks at the data on "Date List" and fills in C10 with the correct month based on the number in cell B10. But for some reason, I keep getting an "#N/A" error.

I did a Vlook up earlier with no problems. Just can't figure this one out!

Thank you all.

Dave

[JieJenn]

You are looking up numeric value and when the vlookup is using string trying to match your value. Change your formula to =INDEX('Date List'!$A$2:$A$72,'Main Sheet'!B10)

[Olly]

VLOOKUP matches the value in the leftmost column of the stated range, and return the matching row value in the column 'n' to the right, based on the third argument of the formula...

Your VLOOKUP formula is trying to match a number with a Month string, in [Date List] column A - of course, it can't find it, so it returns #N/A.

If you are just using that number (in B10) to return the month name from column A of [Date List], then why not use an INDEX:
In cell C10 enter

=INDEX('Date List'!A2:A72,B10)