Thursday, February 21, 2013

yogi_Match A Column In Another Sheet And Pull The Corresponding Value In Another Column Of The Other Sheet


                                          Google Spreadsheet   Post  #1041
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Feb 22, 2013
user adb9000 said:(http://productforums.google.com/forum/?zx=3s6yw9idkqjm#!category-topic/docs/spreadsheets/FNDwy6DW4HA)
Help with Query 
I am pulling my hair out trying to figure out this one.


If you look at the doc, you will see that in Sheet1 I have an Internal IP column and an External IP column.
What I am trying to accomplish is pulling the Internal IP from Sheet1 into the External IP of Sheet2 by comparing External IP on Sheet2 to External IP.
Can someone please take a look and see what I am doing wrong?

Thanks!
------------------------------------------------------------------------------------------------------                                            

following is a solution to the problem