N/A

[bohon79]

Hello,

I have a code in a cell that looks at another cell and based on what is in there it autofills the cell in. below is the code that currently works:

=INDEX(PERSONNEL!$A$2:$A$20,MATCH(HQS!B6,PERSONNEL!$C$2:$C$20,0))

But when I have nothing in the cell (B6), Cell (A6) comes up with n/a. is there a way to have the cell be blank when there is nothing in Cell B6.

Erick

 

[FormR]

Hi, you just posted this exact question to another thread

https://www.mrexcel.com/forum/excel-questions/1026405-vlookup.html

 

[Johnny C]

=iferror(index(personnel!$a$2:$a$20,match(hqs!b6,personnel!$c$2:$c$20,0)),"")
=if(b6="","",index(personnel!$a$2:$a$20,match(hqs!b6,personnel!$c$2:$c$20,0)))

 

[Peter_SSs]

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per #12 of the Forum Rules and points 6 & 7 of the Forum Use Guidelines.

Any bumps, clarifications, or follow-ups should be posted to the linked thread.