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,
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,
---
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
No comments:
Post a Comment