Tuesday, November 6, 2012

yogi_LookUp Data From Monthly Sheets Using The Monthly Sheet Name As A Variable


                                           Google Spreadsheet   Post  #855
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Nov 06, 2012
user Emil.Katz said : (http://productforums.google.com/forum/?zx=xdgf04nj8c5p#!mydiscussions/docs/s4pRD0Z0BDA)
Using the Vlookup formula with the array connected to a cell
Hello!

I have a simple problem that I hope someone could help me with!

I´m building a report sheet where I want to use the Vlookup formula to collect data from the other sheets in the document.

The normal forumla is very simple and looks like this "=vlookup(B6,okt!B4:D11,2,False)"

What I want to do is to replace okt with a reference to a cell, for an example b2, in which the name of different sheets in the same document is written in a (data--->Validation) list.

The formula that i would like to write is something like this 
"=vlookup(B6,b2!B4:D11,2,False)"

---

Could you please look in the link and se if you can figure out a solution?

--------------------------------------------------------------------------------------

since the dropDown list includes superfluous space characters, I used the TRIM function with cell B2 to take care of the space character