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 |
#11
|
|||
|
|||
Problem with Vlookup
Cheers..
If this post helps click Yes --------------- Jacob Skaria "Confused" wrote: Thank you. Trim worked. Now I am getting correct answers "Jacob Skaria" wrote: Please check for spaces in your original data. Try =LEN(A1) and compare the len. If different TRIM your data and try lookup.. -- If this post helps click Yes --------------- Jacob Skaria "Confused" wrote: 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. "Eduardo" wrote: 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 "Confused" wrote: 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? |
|
Thread Tools | |
Display Modes | |
|
|