Problem with Vlookup

  • Thread starter Thread starter Confused
  • Start date Start date
C

Confused

I am using Vlookup to find names in one file and replace it with emails from
another. The two names exist in both files but i get all #N/A . How can I
resolve this?
 
Hi,
Check that the names are identical sometimes one of them has an space or
other simbol,

2) Highlight both columns and do text to columns
 
The data is arranged in 2 excel spreadsheets in columns. The names are
written the same way and both formatted as text. I hve tried formatting both
columns same way. same problem. If I retype both names in the two
spreadsheets the correct info is returned.
 
Please check for spaces in your original data.
Try =LEN(A1) and compare the len. If different TRIM your data and try lookup..
 
The data is arranged in columns in excel spreadsheets. The names are
displaying the same way. I have formatted them all as text. The formula I use
is :=VLOOKUP(38, A2:C10, 3, FALSE).
 
Confused said:
The data is arranged in 2 excel spreadsheets in columns. The names are
written the same way and both formatted as text. I hve tried formatting both
columns same way. same problem. If I retype both names in the two
spreadsheets the correct info is returned.
Click to expand...
....

Formatting is COMPLETELY IRRELEVANT. Formatting changes only how cells
are displayed, not the cells' underlying values. Formulas work only on
the underlying values which formatting doesn't affect.
 
Hi,
If you retype the names and works there is something different, try in both
columns

=trim(a1)
and copy all the way down
 
Is 38 the number you are looking for. In your orignal post you have mentioned
that you are looking the name to get the email id.

Try replacing the number with a text string which is present in the table
and see..
=VLOOKUP("John", A2:C10, 3, FALSE)

If this dont work please let us know how the data is arranged...

If this post helps click Yes
 
Back
Top