Thursday, December 20, 2012

yogi_Search Spreadsheet (with key in cell A3) In Specified Column Range (cell B3) For Specified Entry (cell C3)


                                          Google Spreadsheet   Post  #932
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Dec 20, 2012
user rpjd said:(http://productforums.google.com/forum/?zx=hx7azbbj29bn#!category-topic/docs/spreadsheets/2r_nNqwMjnE)
Vlookup in external worksheet 
I want to search (using a vlookup if possible) another (external) Google spreadsheet for a particular value.  Can another advise on how I do this?
---
here is a view of the spreadsheet to be searched: 



following is a solution to the problem


No comments:

Post a Comment