MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Vlookup returns #NA

  Asked By: Bertha    Date: Nov 06    Category: MS Office    Views: 1361

I have a problem with Vlookup. The formula is returning an #NA.
I know the value which is a string contained in the array but I can no
get the expected result.
If i use the formula =MATCH(D3,'Server to Cluster'!$B$1:$B$80,0)
The relative position returned is 11 as expected. However when I use
=VLOOKUP(D3,'Server to Cluster'!$A$1:$B$80,1,FALSE) I get #NA.

I need the cluster number in cell A11.

Sheet 1
In D3 is a hostname
The formula is in column E

Sheet 2 is Server to Cluster
Column A contains the cluster number that I need
Column B contains the server numbers to match.



2 Answers Found

Answer #1    Answered By: Varick Fischer     Answered On: Nov 06

The value you are using for the lookup has to be the leftmost column of the
lookup range. In other words, the server  numbers have to be in a column to the
left of the cluster numbers. You could insert a new column A and copy the server
number column to it. Or, you could copy the cluster number column to column C
and do the VLookups against columns B:C.

Answer #2    Answered By: Haboos Kauser     Answered On: Nov 06

I feel so stupid that worked. It is a shame that I spent hours
looking at this trying to figure it out.

Didn't find what you were looking for? Find more on Vlookup returns #NA Or get search suggestion and latest updates.