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
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(,!B4:D11,2,
What I want to do is to replace "=vlookup(,!B4:D11,2,
since the dropDown list includes superfluous space characters, I used the TRIM function with cell B2 to take care of the space character