Vlookup and #N/A

L

Linda1hu

Hi,

My problem is the following.

I have two spreadsheets. I copied a coloum with numbers and pasted it to the
other spreadsheet. Now I created a Vlookup formula (=VLOOKUP(E5,'Query
Download'!$A$1:$C$418,3, FALSE) next to the first cell. The result is #N/A a
few times which is fine coz sometimes there there are no result but the other
times should be something.

So what I did is I got into the cell which contains the numbers (the coloum
with numbers) with F2 or double click and then enter. And worked. BUT I DONT
KNOW WHY and I don't know what has been changed?

Is there any chance that I can change the cells all together and not one by
one and I will have result where I should have?

Thanks
Linda
 
B

Bob Phillips

It sounds as though some of your data is formatted as text. You will need to
do what you are doing, but maybe select them all and just Fr then Enter in a
big sweep.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
E

Eladamri

Hi im new at this forum but i hope this is helpful.

try double checking checking the cell format used. if there is nothing
wrong with that (i.e. amounts should be in general or number format and
not text)
try inserting a row on top of the list.
type "1" on th first row and copy it.
highlight the rest of the data and right click --> Paste Special -->
Poeration -->Multiply.

It should work provided there is no other errors.
 
E

Eladamri

Hi im new at this forum but i hope this is helpful.

try double checking checking the cell format used. if there is nothing
wrong with that (i.e. amounts should be in general or number format and
not text)
try inserting a row on top of the list.
type "1" on th first row and copy it.
highlight the rest of the data and right click --> Paste Special -->
Poeration -->Multiply.

It should work provided there is no other errors.
 
L

Linda1hu

Thank you for your quick replay.

Unfortunately it doesnt work. When I select them all and F2 (Fr) and enter
the cursor go to the next cell. I have no idea what to do. I checked the
format and everything is general.

Linda
 
B

Bob Phillips

He means the Operation section Linda.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top