Tuesday, July 16, 2013

Google Spreadsheet Vlookup for entire column with arrayformula


( 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:


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


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 


No comments:

Post a Comment