Compare values in two columns and return the value from third
Closed
jtliapp
Posts
2
Registration date
Friday January 12, 2018
Status
Member
Last seen
January 26, 2018
-
Jan 12, 2018 at 11:47 PM
jtliapp Posts 2 Registration date Friday January 12, 2018 Status Member Last seen January 26, 2018 - Jan 26, 2018 at 05:33 PM
jtliapp Posts 2 Registration date Friday January 12, 2018 Status Member Last seen January 26, 2018 - Jan 26, 2018 at 05:33 PM
Related:
- Compare values in two columns and return the value from third
- Display two columns in data validation list but return only one - Guide
- Beyond compare - Download - File management
- Which function is used to compare a cell value to an array of cells and return a value that matches the location of the value in the array, and is used when there are more than two columns in the array ✓ - Excel Forum
- If cell contains date then return value ✓ - Excel Forum
- Excel "IF" function w/ date in test cell ✓ - Excel Forum
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jan 13, 2018 at 07:25 AM
Jan 13, 2018 at 07:25 AM
jtlipp, Good morning.
Try to use:
ARRAY FORMULA
=INDEX(C1:C100, MATCH("Under review" & MIN(B1:B100), A1:A100&B1:B100,0))
Press CTRL+SHIFT+ENTER
Please, tell us if it worked as you want.
I hope it helps.
--
Belo Horizonte, MG - Brasil.
Marcílio Lobão
Try to use:
ARRAY FORMULA
=INDEX(C1:C100, MATCH("Under review" & MIN(B1:B100), A1:A100&B1:B100,0))
Press CTRL+SHIFT+ENTER
Please, tell us if it worked as you want.
I hope it helps.
--
Belo Horizonte, MG - Brasil.
Marcílio Lobão
Jan 26, 2018 at 05:33 PM