Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Worksheet Functions > #N/A Error on VLOOKUP
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 21
Default #N/A Error on VLOOKUP
I have this formula:

=VLOOKUP(A20,EmpInfo,2)

If A20 is Blank, I want the cell blank - instead I am getting #N/A

What am I doing wrong?
Reply With QuoteReply With Quote
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 2,722
Default #N/A Error on VLOOKUP
=IF(ISBLANK(A20),"",VLOOKUP(A20,EmpInfo,2))

--
Best Regards,

Luke M


"roxiemayfield" wrote:

I have this formula:

=VLOOKUP(A20,EmpInfo,2)

If A20 is Blank, I want the cell blank - instead I am getting #N/A

What am I doing wrong?
Reply With QuoteReply With Quote
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 3,268
Default #N/A Error on VLOOKUP
=IF(ISNA(VLOOKUP(A20,EmpInfo,2)),"",VLOOKUP(A20,Em pInfo,2))

or probably

=IF(ISNA(VLOOKUP(A20,EmpInfo,2,0)),"",VLOOKUP(A20, EmpInfo,2,0))


--


Regards,


Peo Sjoblom





"Luke M" wrote in message
...
=IF(ISBLANK(A20),"",VLOOKUP(A20,EmpInfo,2))

--
Best Regards,

Luke M


"roxiemayfield" wrote:

I have this formula:

=VLOOKUP(A20,EmpInfo,2)

If A20 is Blank, I want the cell blank - instead I am getting #N/A

What am I doing wrong?


Reply With QuoteReply With Quote
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 21
Default #N/A Error on VLOOKUP
Still giving me the #N/A

"Luke M" wrote:

=IF(ISBLANK(A20),"",VLOOKUP(A20,EmpInfo,2))

--
Best Regards,

Luke M


"roxiemayfield" wrote:

I have this formula:

=VLOOKUP(A20,EmpInfo,2)

If A20 is Blank, I want the cell blank - instead I am getting #N/A

What am I doing wrong?
Reply With QuoteReply With Quote
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 21
Default #N/A Error on VLOOKUP
This one is giving me FALSE unless the cell is blank, then I am still getting
#N/A

"Peo Sjoblom" wrote:

=IF(ISNA(VLOOKUP(A20,EmpInfo,2)),"",VLOOKUP(A20,Em pInfo,2))

or probably

=IF(ISNA(VLOOKUP(A20,EmpInfo,2,0)),"",VLOOKUP(A20, EmpInfo,2,0))


--


Regards,


Peo Sjoblom





"Luke M" wrote in message
...
=IF(ISBLANK(A20),"",VLOOKUP(A20,EmpInfo,2))

--
Best Regards,

Luke M


"roxiemayfield" wrote:

I have this formula:

=VLOOKUP(A20,EmpInfo,2)

If A20 is Blank, I want the cell blank - instead I am getting #N/A

What am I doing wrong?



Reply With QuoteReply With Quote
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 8,856
Default #N/A Error on VLOOKUP
Try it this way:

=IF(A20="","",VLOOKUP(A20,EmpInfo,2))

then copy down if required. Ensure that A20 and other cells below it
are blank, and not containing spaces.

Hope this helps.

Pete

On Dec 7, 8:15 pm, roxiemayfield
wrote:
Still giving me the #N/A



"Luke M" wrote:
=IF(ISBLANK(A20),"",VLOOKUP(A20,EmpInfo,2))

--
Best Regards,

Luke M

"roxiemayfield" wrote:

I have this formula:

=VLOOKUP(A20,EmpInfo,2)

If A20 is Blank, I want the cell blank - instead I am getting #N/A

What am I doing wrong?- Hide quoted text -

- Show quoted text -

Reply With QuoteReply With Quote
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 21
Default #N/A Error on VLOOKUP
Thank you! I think that will work.

"Pete_UK" wrote:

Try it this way:

=IF(A20="","",VLOOKUP(A20,EmpInfo,2))

then copy down if required. Ensure that A20 and other cells below it
are blank, and not containing spaces.

Hope this helps.

Pete

On Dec 7, 8:15 pm, roxiemayfield
wrote:
Still giving me the #N/A



"Luke M" wrote:
=IF(ISBLANK(A20),"",VLOOKUP(A20,EmpInfo,2))

--
Best Regards,

Luke M

"roxiemayfield" wrote:

I have this formula:

=VLOOKUP(A20,EmpInfo,2)

If A20 is Blank, I want the cell blank - instead I am getting #N/A

What am I doing wrong?- Hide quoted text -

- Show quoted text -


Reply With QuoteReply With Quote
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 8,856
Default #N/A Error on VLOOKUP
Glad to hear it - thanks for feeding back.

Pete

On Dec 7, 8:50 pm, roxiemayfield
wrote:
Thank you! I think that will work.



"Pete_UK" wrote:
Try it this way:

=IF(A20="","",VLOOKUP(A20,EmpInfo,2))

then copy down if required. Ensure that A20 and other cells below it
are blank, and not containing spaces.

Hope this helps.

Pete

On Dec 7, 8:15 pm, roxiemayfield
wrote:
Still giving me the #N/A

"Luke M" wrote:
=IF(ISBLANK(A20),"",VLOOKUP(A20,EmpInfo,2))

--
Best Regards,

Luke M

"roxiemayfield" wrote:

I have this formula:

=VLOOKUP(A20,EmpInfo,2)

If A20 is Blank, I want the cell blank - instead I am getting #N/A

What am I doing wrong?- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

Reply With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
vlookup error ken gault Excel Worksheet Functions 3 November 16th 07 07:57 PM
vlookup error [email protected] Excel Worksheet Functions 5 May 31st 07 02:52 PM
vlookup error Vlookup not accurate Excel Discussion (Misc queries) 9 October 5th 06 04:06 PM
VLOOKUP error Mr. Boyer Excel Worksheet Functions 3 May 19th 06 04:50 PM
Vlookup Error mick.smith1964 Excel Worksheet Functions 5 January 13th 05 10:03 PM


All times are GMT +1. The time now is 04:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Contact Us ExcelBanter forum home Privacy Statement