IF and Vlookup functions GoogleSheets

RamsJ

New Member
Joined
Feb 20, 2019
Messages
3
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!
 
Last edited by a moderator:

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
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.
 
Upvote 0
Re: Need help with IF and Vlookup functions

@RamsJ
Is this a GoogleSheets question?
 
Upvote 0
Re: Need help with IF and Vlookup functions

Yes, trying this function in a google sheet
 
Upvote 0
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.
 
Upvote 0
Re: Need help with IF and Vlookup functions

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

Forum statistics

Threads
1,213,535
Messages
6,114,198
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top