Fill cells in one sheet one column with values from other spreadsheets matching 2 criteria

Hi Synthia
Try using the AND function with two VLOOKUP functions, for example:

=IF(AND(VLOOKUP("ONE",A:B,2,FALSE),VLOOKUP("Two",C:D,2,FALSE)),"Yes","No")

Without seeing the actual worksheets you want populated it is difficult to help you more accurately.
Hope this helps.
Good luck.
Tony

Sorry, you are right, I modified original message just now, it should have been and is now "Elem FCAT Reading".
Thanks,
Synthia

HI ARGK,
The actual worksheet to be populated is "Elem FCAT Reading"
Thanks, Synthia

for forum 5 rev.xlsx
The matching columns were wrong, too. It is column B & D, and I had to insert a column in the sheet to fill, "Elem FCAT Reading" to make them line up.
Sorry, Attached revised version.
Thanks for any help you can offer!!!
Synthia

Hi Synthia
You mention columns B and D need to match. Which worksheet are you referring to and what do the columns have to match with.
Tony

HI Tony,
The worksheet "Elem FCAT Reading" has:
District Number in column B
School Number in column D
3rd grade 2012 RDG % ≥ Lvl 33 in column F (blank to be filled from: "2012 r3 sch" column M for rows that have the same District Number in column B & School Number in column D)
3rd grade 2013 RDG % ≥ Lvl 33 in column G (blank to be filled from: "2013 r3sch" column M for rows that have the same District Number in column B & School Number in column D)

4th grade 2012 RDG % ≥ Lvl 33 in column I (blank to be filled from: "2012 r4_sch" column M for rows that have the same District Number in column B & School Number in column D)

4th grade 2013 RDG % ≥ Lvl 33 in column J (blank to be filled from: "2013 r4_sch" column M for rows that have the same District Number in column B & School Number in column D)

for forum 5 rev.xlsx

Does that make sense?
Thanks for any help you can offer!
Synthia

Hi Synthia
That makes it much clearer , thanks.
If the School name is unique (which it appears to be) then why can you not use VLOOKUP on the School Name, or have I missed something?
Tony

Hi Synthia
Please find herewith your solution which I hope works for you.
I have done the 2012 r3 sch sheet for you which you can follow for the remaining sheets.
Here's how it works:
1. In Sheet "Elem ECat Reading" I have inserted an extra column (Col A) and in that column I have concatenated the District No and School Number into one field.
2. Then I have formatted the Columns A, B and D to be numbers with no decimal places.
3. In Sheet "2012 r3 sch" I have again inserted a new Column (Col A) and done the same with the District No and School number into Col A.
4. Then on the "Elem ECat Reading" sheet in column F I have created a single VLOOKUP to return the values you need from the "2012 r3 sch" sheet. The first part of the VLOOKUP just checks to see if the value value can be found, if not leave the cell blank, if the value is found then return it.

You can use this formula for the remainder of the values you need to populate the main Summary sheet.
If you need further help then come back to me.
Tony

THANK YOU SO MUCH, That is AMAZING. I am very grateful and hope I can help you or someone else that way someday!Gratefully, Synthia

If you ever do this for a fee that is mall enough for someone in education to pay, please send me contact info!
(-:

synses@live.com

Hi Synthia
Make sure that all your School and District numbers are formatted as numbers with no decimal places and that should help.
Tony