Seamus2626
asked on
Remove NA error
Hi,
I have the below formula which returns some NA errors, can i add to it so if its an NA error it returns blank for that cell
=IF(E8="8455",VLOOKUP(Fisc al_Merit!G 11,'8455'! E:F,2,0),I F(E8="8456 ",VLOOKUP( Fiscal_Mer it!G11,'84 56'!E:F,2, 0),IF(E8=" 8457",VLOO KUP(Fiscal _Merit!G11 ,'8457'!E: F,2,0))))
Thanks
Seamus
I have the below formula which returns some NA errors, can i add to it so if its an NA error it returns blank for that cell
=IF(E8="8455",VLOOKUP(Fisc
Thanks
Seamus
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Cheers guys!
=IFERROR(VLOOKUP(Fiscal_Me
barry