Google Spreadsheet Post #1113
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Apr 11, 2013
user cbtanner :(http://productforums.google.com/forum/?zx=kt0soilg3ufa#!category-topic/docs/spreadsheets/a2o8huI25TA)
Ok so I've tried to figure this out from other threads but I haven't been able to find exactly what I'm trying to do.
So I've been trying to create a function that will run a "vlookup" from a master spreadsheet, while referencing specific cells on a given tabs whose name is being referenced above
As is what I've written is =QUERY( ImportRange( "
Where "FB!$A:$B" is the range of cells that I'm looking at from the master spreadsheet, B9 is the specific cell on the other tab where I'm pulling the info from, and J1 is the name of tab that I'm trying to reference.
If anybody could help me with this I'd be very grateful
---
Ok so I've created sample versions of the sheets and the links are below. Thanks again for the help!
I hope the info on the sheet makes sense
------------------------------------------------------------------------------------------------------
following is a solution to the problem
No comments:
Post a Comment