Excel vlookup quarry

Save Share

This query is : Resolved

Goongan (Querist)

10 August 2013 Dear All,

We are using VLOOKUP formula also the result of VLOOKUP is input of another formula. If the result of VLOOKUP is in number, than there is no problem for next dependent formula. But when result of VLOOKUP is “#N/A” (being the corresponding value for VLOOKUP not availed) than the result of next formula also become “#N/A”. Whether it is possible to convert “#N/A” (if the corresponding value for VLOOKUP not availed) to “0” automatically.

Thank You In Advance

@VaibhavJ

@VaibhavJ (Expert)

10 August 2013 hi

Yes!!

You use iferror() or isna() with if() to convert result in to zero.

Try using iferror(), this will solve your problem. Apply before your final formula,

If you need help in writing formula let me know.

Thanks!!

Message likes : 1 times

Goongan

Goongan (Querist)

10 August 2013 Thanks,

I do it ......
as bellow,

IFERROR(VLOOKUP(B197,STANDBY!C:J,8,0),0)

@VaibhavJ

@VaibhavJ (Expert)

10 August 2013 yep.. you did right!!

Bingo!!

@VaibhavJ

@VaibhavJ (Expert)

10 August 2013 i see one more error in your formula~~

you have not made absolute reference to cell C:J.

So when you try to drag or copy & paste formula to other raw you will get answer as zero, but that is not right result.

Cheers!!

You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now