Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|