Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Bertha Ferguson   on Nov 06 In MS Office Category.

  
Question Answered By: Varick Fischer   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.

Share: