Wednesday, April 22, 2015

yogi_LookUp Scores For Specified Names If There Are Matching Scores For Corresponding Names In Sheet1 And Sheet2


                                           Google Spreadsheet   Post  #1948
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Apr-22, 2015
question by Ms. Cleveland:
https://productforums.google.com/forum/#!mydiscussions/docs/xk0vc9YTJyE
Compare columns in different Google Spreadsheets
I have 2 separate spreadsheets that I want to compare. First, I want to compare names in 2 columns in different spreadsheets/tabs. Second, it their is a match, compare the numbers in 2 columns in different spreasheets/tabs that are associated with the name match. Last, if the names and numbers match, place the number next to the name in another column, in the second spreadsheet. The names in the last column are already populated. Here is what I have so far. 
=IF(AND($D$2:$D$100=QBW2!$O$2:$O$100,$E$2:$E$100=QBW2!$P$2:$P$100,E2:E100))
I want to match a name in column D(sheet1) to column O(sheet2).
 I want to match a number in column E(sheet1) to column P(sheet2).
 If the information matches, place the number next to the name(which is in D) in column P(sheet2).
---
Here is the link below.

My Objective:
If sheet1 column B matches with sheet2 column C 
AND
If sheet1 column C matches with sheet2 column D
THEN
Place their matching score next to their name in column I
IF NO MATCH OCCURED
Place a "0" in the column next to their name

The names are already populated in row H in order.
------------------------------------------------------------------------------------------------------------------