If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Lookup returns N/A
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? |
#2
|
|||
|
|||
Lookup returns N/A
Difficult to say without your formulas, ranges and values.
-- Kind Regards, Niek Otten Microsoft MVP - Excel wrote in message ... 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? |
#3
|
|||
|
|||
Lookup returns N/A
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 wrote in message ... 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? |
Thread Tools | |
Display Modes | |
|
|