Report

Need to match two values and return another value

Ask a question Stacey1992 1Posts Thursday September 15, 2016Registration date September 15, 2016 Last seen - Latest answer on Sep 15, 2016 11:30AM
I have two spreadsheets in which I need to match two values and return another value. So, in my case, if Column C and Row 24 match (in spreadsheet A) Column A and Column D (in spreadsheet B), return Column P value (from spreadsheet B to Spreadsheet A) in Column P.
Any assistance would be greatly appreciated!!!
See more 
Helpful
+0
moins plus
Stacey1992, Good morning.

Try to use:

Sheet 1

P24 --> =IF(AND(C24=Sheet2!A24,C24=Sheet2!D24),Sheet2!P24,"")

Please, tell us if it worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Add comment

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.

Not a member yet?

sign-up, it takes less than a minute and it's free!