Vlookup function across data copied from various sources

S

Scarlett

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?
 
S

Shane Devenshire

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 - D1:D100?

Most of the time N/A means that the function failed to find the item you
were looking up.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup function wont work for copied data 2
Adding up total hours worked on employee schedule using various criteria 0
VLOOKUP with a blank cell 5
Vlookup Help 2
VLOOKUP with a Named Range argument 1
INDIRECT(ADDRESS) inside a VLOOKUP 13
vlookup error 1
Embedded If Function in a Vlookup Function 2

Top