Need to match two values and return another value
Closed
Stacey1992
Posts
1
Registration date
Thursday 15 September 2016
Status
Member
Last seen
15 September 2016
-
15 Sep 2016 à 09:53
Mazzaropi Posts 1985 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 15 Sep 2016 à 11:30
Mazzaropi Posts 1985 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 15 Sep 2016 à 11:30
Related:
- Need to match two values and return another value
- Music match jukebox - Download - Audio playback
- Display two columns in data validation list but return only one - Guide
- Thunderbird return receipt - Guide
- Partial match excel - Guide
- Based on the values in cells b77 b88 - Excel Forum
1 response
Mazzaropi
Posts
1985
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
15 Sep 2016 à 11:30
15 Sep 2016 à 11:30
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
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
