Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup prob with all #n/a's
What am I not gettin?
I have a list in column A. I want to find an exact match on column B if there is one. I have the vlookup formula in column C. In column C all I get is #n/a. There are some matches so something is wrong with my formula. Please help. tia, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup prob with all #n/a's
Assuming you have the formula correct then it could be an issue with your
source data. Check for blank characters at the end of each item in the list. If your list was a download from another system very often you get blank characters padded at the end. -- HTH... Jim Thomlinson "Janis" wrote: What am I not gettin? I have a list in column A. I want to find an exact match on column B if there is one. I have the vlookup formula in column C. In column C all I get is #n/a. There are some matches so something is wrong with my formula. Please help. tia, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup prob with all #n/a's
Sorry, I forgot to give you the formula:
=VLOOKUP(A3,A:B,2,FALSE) It does not appear to be right and I'm having trouble understanding the vlookup function. Something should be matching. thanks, "Jim Thomlinson" wrote: Assuming you have the formula correct then it could be an issue with your source data. Check for blank characters at the end of each item in the list. If your list was a download from another system very often you get blank characters padded at the end. -- HTH... Jim Thomlinson "Janis" wrote: What am I not gettin? I have a list in column A. I want to find an exact match on column B if there is one. I have the vlookup formula in column C. In column C all I get is #n/a. There are some matches so something is wrong with my formula. Please help. tia, |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup prob with all #n/a's
Where is your "lookup" value?
What is your "Lookup Table"? Which is your "column index" number? Show us your formula please. Gord Dibben MS Excel MVP On Mon, 30 Jul 2007 10:42:00 -0700, Janis wrote: What am I not gettin? I have a list in column A. I want to find an exact match on column B if there is one. I have the vlookup formula in column C. In column C all I get is #n/a. There are some matches so something is wrong with my formula. Please help. tia, |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup prob with all #n/a's
I copied the lookup values to column A on sheet1. I copied the cells I want
to see if there is a match in to column B on sheet1. I copied this formula to column C where I want to see if there is a match or not. Am I supposed to have a value in column D or can I only have 3 columns? to make it work or should I just use a lookup instead of a vlookup? It seems impossibly hard to do the vlookup directly on the sheets themselves so I copied the columns to a new sheet. I still can't get it to work. I think the vlookup is not very intuitive. Unfortunately I have all these sheets I have to find matching values. I would like to understand it. thanks, "Gord Dibben" wrote: Where is your "lookup" value? What is your "Lookup Table"? Which is your "column index" number? Show us your formula please. Gord Dibben MS Excel MVP On Mon, 30 Jul 2007 10:42:00 -0700, Janis wrote: What am I not gettin? I have a list in column A. I want to find an exact match on column B if there is one. I have the vlookup formula in column C. In column C all I get is #n/a. There are some matches so something is wrong with my formula. Please help. tia, |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup prob with all #n/a's
Why do I have to have a lookup table? Why can't I just have a lookup column?
"Gord Dibben" wrote: Where is your "lookup" value? What is your "Lookup Table"? Which is your "column index" number? Show us your formula please. Gord Dibben MS Excel MVP On Mon, 30 Jul 2007 10:42:00 -0700, Janis wrote: What am I not gettin? I have a list in column A. I want to find an exact match on column B if there is one. I have the vlookup formula in column C. In column C all I get is #n/a. There are some matches so something is wrong with my formula. Please help. tia, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 prob | Excel Discussion (Misc queries) | |||
Macro Prob | Excel Worksheet Functions | |||
spreadsheet not working prob | Excel Discussion (Misc queries) | |||
Counting prob | Excel Discussion (Misc queries) | |||
A little help, prob simple to anyone else | New Users to Excel |