Tuesday, July 16, 2013

Google Spreadsheet Vlookup for entire column with arrayformula

Question:

( by notacare01 )

Hello, I'm trying to have my spread sheet automatically input the time zone of the area code in column A

here is the screenshot of my spreadsheet:





Solution:

To auto calculate for the entire column B, put the following formula in Cell B1:

=arrayformula(if(row(A:A)=1;"Timezone";iferror(VLOOKUP(A:A;$F$2:$G$48;{2}*SIGN(ROW(A:A));false))))

Have a look at the following screenshot:




I hope the above solution will help you, and if you need more help then please do comment below on this blog itself, I will try to help you out.

I also take up private and confidential projects:
If this blog post was helpful to you, and if you think you want to help me too and make my this blog survive then please donate here: http://igoogledrive.blogspot.com/2012/09/donate.html 

Thanks,

No comments:

Post a Comment