Thursday, April 11, 2013

yogi_Pull Fabric Type From Another Spreadsheet By Indirectly Matching Reference To An Entity Of A Specified Order


                                          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( "0AkCBWZdHfNGkdGdOM1R0V1NjVjlNc1A3OUtRd3pOZUE" ; "FB!$A:$B" ) ; "select Col2 where Col1 = B9" &"(J1)"!{} & "' limit 1" ) 

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