IF and Vlookup functions GoogleSheets

[RamsJ]

Hi, I'm trying to use iferror, arrayformula and vlookup functions together..

This is the formula I've used =iferror(arrayformula(VLOOKUP(D2:D,'Full Org'!J2:K1000,2,0)),"Chennai")

If the vlookup didnt fetch any value, it should display Chennai. Here, the problem is I need to add one more check that if column A is null, then it should not return any value as it is displaying as Chennai for all the blank rows as well. Kindly help!

 

[Special-K99]

Re: Need help with IF and Vlookup functions

What's "arrayformula" ? Is this an Excelfunction or some form of UDF ?
What's D2:D ? That's not a proper range is it ?

Do a COUNTA on column A to determine all cells are not blank.

 

[Fluff]

Re: Need help with IF and Vlookup functions

@RamsJ
Is this a GoogleSheets question?

 

[RamsJ]

Re: Need help with IF and Vlookup functions

Yes, trying this function in a google sheet

 

[RamsJ]

Re: Need help with IF and Vlookup functions

Trying the function in a google sheet. D2:D= trying to select the complete column.. it is working fine. Will try countA function.

 

[Fluff]

Re: Need help with IF and Vlookup functions

In that case I have moved you question to the correct board & updated the title.