Lookup returns N/A

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a worksheet with the following columns:

Client Number Client Name

These two columns are the result of a query that is
pulled from an accounting package called Timberline which
uses ODBC.

The next worksheet looks already has the client numbers
in random order, so I created a look up that says, if
cell C2 is equal to 34, then look at sheet 1, find 34 and
return the assoicated client name. Simple V-Lookup. So
why does it keep returning N/A? I tried to copy and
paste special -- Add, but that when I paste-Add nothing
pastes in. What am I doing wrong?
 
Difficult to say without your formulas, ranges and values.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
One cause of the problem may be that in your VLOOKUP formula, Excel is
looking for the number 34 while the info pulled from Timberline might be
formatted as text. You could try putting quotes around the number 34 in
your VLOOKUP to see if this helps.

--
Michael J. Malinsky
Pittsburgh, PA

"I am a bear of very little brain, and long
words bother me." -- AA Milne, Winne the Pooh
 
Back
Top