ExcelBanter - Vlookup and #N/A

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Vlookup and #N/A (https://www.excelbanter.com/excel-discussion-misc-queries/92149-vlookup-n.html)

Linda1hu

Vlookup and #N/A

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

Bob Phillips

Vlookup and #N/A

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)

"Linda1hu" wrote in message
...
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

Eladamri

Vlookup and #N/A

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.

--
Eladamri
------------------------------------------------------------------------
Eladamri's Profile: http://www.excelforum.com/member.php...o&userid=35099
View this thread: http://www.excelforum.com/showthread...hreadid=548548

Eladamri

Vlookup and #N/A

Linda1hu

Vlookup and #N/A

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

"Bob Phillips" wrote:

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)

"Linda1hu" wrote in message
...
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

Linda1hu

Vlookup and #N/A

Hi thanks,

'Poeration' - what is it. I can't see on mine.

"Eladamri" wrote:

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.

--
Eladamri
------------------------------------------------------------------------
Eladamri's Profile: http://www.excelforum.com/member.php...o&userid=35099
View this thread: http://www.excelforum.com/showthread...hreadid=548548

Bob Phillips

Vlookup and #N/A

He means the Operation section Linda.

--
HTH

Bob Phillips

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

"Linda1hu" wrote in message
...
Hi thanks,

'Poeration' - what is it. I can't see on mine.

"Eladamri" wrote:

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.

--
Eladamri
------------------------------------------------------------------------
Eladamri's Profile:
http://www.excelforum.com/member.php...o&userid=35099
View this thread:
http://www.excelforum.com/showthread...hreadid=548548

All times are GMT +1. The time now is 03:09 AM.