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    Dec 20, 2012
user rpjd said:(!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