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
|
|||
|
|||
Problem with Vlookup
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? |
#2
|
|||
|
|||
Problem with Vlookup
Let us know how your data is arranged. and also the formula you have used./
-- If this post helps click Yes --------------- Jacob Skaria "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? |
#3
|
|||
|
|||
Problem with Vlookup
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? |
#4
|
|||
|
|||
Problem with Vlookup
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? |
#5
|
|||
|
|||
Problem with Vlookup
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? |
#6
|
|||
|
|||
Problem with Vlookup
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). "Jacob Skaria" wrote: Let us know how your data is arranged. and also the formula you have used./ -- If this post helps click Yes --------------- Jacob Skaria "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? |
#7
|
|||
|
|||
Problem with Vlookup
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. .... 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. |
#8
|
|||
|
|||
Problem with Vlookup
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 --------------- Jacob Skaria "Confused" wrote: 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). "Jacob Skaria" wrote: Let us know how your data is arranged. and also the formula you have used./ -- If this post helps click Yes --------------- Jacob Skaria "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? |
#9
|
|||
|
|||
Problem with Vlookup
Hi,
If you retype the names and works there is something different, try in both columns =trim(a1) and copy all the way down "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? |
#10
|
|||
|
|||
Problem with Vlookup
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 | |
|
|