Excel vlookup quarry

This query is : Resolved

Goongan (Querist)
Follow

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)
Follow

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)
Follow

10 August 2013 Thanks,

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

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

Upgrade to CAclubindia Pro. Subscribe Now!

@VaibhavJ

@VaibhavJ (Expert)
Follow

10 August 2013 yep.. you did right!!

Bingo!!

@VaibhavJ

@VaibhavJ (Expert)
Follow

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