Previous Topic Next Topic

Need to match two values and return another value

Closed
Stacey1992 Posts 1 Registration date Thursday September 15, 2016 Status Member Last seen September 15, 2016 - Sep 15, 2016 at 09:53 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Sep 15, 2016 at 11:30 AM
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!!!

1 response

Answer 1 / 1
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Sep 15, 2016 at 11:30 AM
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
0

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Compare values in two columns and return the value from third
ramdubai -
keshav -

11 responses
Excel - IF function with multiple words
Nick -
user -

14 responses
If cell = date return yes or no.
JD -
ndwebb -

5 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses