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 2 columns and return a value from third
- 텐타클 락커 2 - Download - Adult games
- Display two columns in data validation list but return only one - Guide
- Tweetdeck larger columns - Guide
- My cute roommate 2 - Download - Adult games
- Fnia 2 - Download - Adult games
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