IF ISBLANK VLOOKUP function is bringing back #NA if the cell it pulls data from is empty.

[Rotherzz]

I have a spreadsheet that pulls personnel details from my main sheet (Nominal) to my other tab.

B1:B50 with contain staff numbers when they are required. so while the tab is empty is shows #NA. When i put the staff number in the formula works fine.

I was wondering if anyone could help to see if i could get my formula to function the same but also prevent the #NA if no staff number is present.

Formula is below.

=IF(ISBLANK(VLOOKUP(B1,'Nominal'!$A$3:$AQ$152,7,FALSE())),"",VLOOKUP(B1'Nominal'!$A$3:$AQ$152,7,FALSE()))

TIA!

 

[Fluff]

Hi & welcome to MrExcel.
How about

=LET(v,VLOOKUP(B1,Nominal!$A$3:$AQ$152,7,FALSE()),IF(ISNA(v),"",IF(v="","",v)))

 

[Rotherzz]

Hi & welcome to MrExcel.
How about

=LET(v,VLOOKUP(B1,Nominal!$A$3:$AQ$152,7,FALSE()),IF(ISNA(v),"",IF(v="","",v)))

Hi Fluff, thanks for responding so fast!

Its worked on a quick template i made ( just had to put the apostrophes back onto the Nominal ). Wont know for sure until im back in work on monday!

I will update the thread then!

 

[Fluff]

There is no need for the apostrophes as the sheet name is a single word.

 

[Rotherzz]

Ah! Learnt something new again!