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    Feb 22, 2013
user adb9000 said:(!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?


following is a solution to the problem