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
|
|||
|
|||
Vlookup function across data copied from various sources
I have copied a table from another source. I am trying to do a vlookup for a
column against this copied table. However N/A is returned. I tried TRIM, CLEAN, nothing works. I re-entered a couple of entries of the table and the vlookup function worked fine. However is there a logic to this problem and how do I make sure that the vlookup works for the entire column? |
#2
|
|||
|
|||
Vlookup function across data copied from various sources
Hi,
Really should show us the formula, what the data in the lookup table looks like and what the data you are looking up is, in otherwords in the formula =VLOOKUP(A1,D1:M100,3,FALSE) What is in A1, what is in the 3rd column of the range D1:M100?, what is in the 1st column of that range - D1100? Most of the time N/A means that the function failed to find the item you were looking up. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Scarlett" wrote: I have copied a table from another source. I am trying to do a vlookup for a column against this copied table. However N/A is returned. I tried TRIM, CLEAN, nothing works. I re-entered a couple of entries of the table and the vlookup function worked fine. However is there a logic to this problem and how do I make sure that the vlookup works for the entire column? |
Thread Tools | |
Display Modes | |
|
|