VLOOKUP problem

**CycloneBrian** · 10-11-2011, 11:02 AM

I have a table that has different names in left column with numbers relating to that name in columns B-Z for years 1986-2011 in Sheet 2.

On a seperate sheet I have a box where a formula populates the name. "Franklin" is the name currently in the reference cell (B$5).

If I enter VLOOKUP(B$5,Sheet 2 range,2,FALSE) then I get a #N/A

If I enter VLOOKUP(B$5,Sheet 2 range,2) than I get the data for the cell above Franklin.

**where Sheet 2 range is actually specific to the range of data

I have made sure I don't have any spaces in either one of the inputs or the table and can't get past this. Anybody know what I am doing wrong?

**TMS** · 10-11-2011, 11:05 AM

Could be that the search item is numeric and the lookup data is text or vice versa.

Is the search range absolute?

Difficult to tell from just a description.

You need the false for an exact match in an unsorted list.

Regards

**NBVC** · 10-11-2011, 11:05 AM

The only other thing that I can think of that can cause that issue is that Franklin is mispelled in one or the other location. Have you double checked that?

**Domski** · 10-11-2011, 11:07 AM

Hi,

There must be something different between the lookup value and that in your data table.

Easiest way to see what this is would be if you could upload a sample worksheet.

Dom

**CycloneBrian** · 10-11-2011, 11:27 AM

I just uploaded a sample file on the original post

Thanks for the help

**NBVC** · 10-11-2011, 11:30 AM

There is a trailing space after Franklin in C36 of Country Yields sheet....

and the formula should be:

=VLOOKUP(B$3,'County yields'!$C$4:$AB$101,Sheet2!I14,FALSE)

**CycloneBrian** · 10-11-2011, 11:41 AM

Thanks a lot. I just figured that I screwed something up in my calculations, not the data I imported from somewhere else having a space after every name.

This site is awesome!!!