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
Hello,

I have a table containing three columns.

Column A shows the status of a product, "To Review", "Under Review", "Review Completed"
Column B shows the date on which the product was submitted, "1-5-2018", 1-6-2018", "1-9-2018"
Column C shows the name of the product, "Flag", "23 Keys", "Door"

I need to return the value of Column C if the product is under review by the oldest date.

Can anybody help??? Thanks in advance.

1 reply

Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
147
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
0
jtliapp
Posts
2
Registration date
Friday January 12, 2018
Status
Member
Last seen
January 26, 2018

Jan 26, 2018 at 05:33 PM
Thank you for your help! It did not work.
0