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

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

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

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

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

#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 -

#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 -

#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 -