Compare values in two columns and return the value from third

jtliapp 1 Posts Friday January 12, 2018Registration date January 12, 2018 Last seen - Jan 12, 2018 at 11:47 PM - Latest reply: Mazzaropi 1698 Posts Monday August 16, 2010Registration dateContributorStatus January 22, 2018 Last seen
- Jan 13, 2018 at 07:25 AM
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.
See more 

1 reply

Reply to this topic
Mazzaropi 1698 Posts Monday August 16, 2010Registration dateContributorStatus January 22, 2018 Last seen - Jan 13, 2018 at 07:25 AM
0
Helpful
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
Respond to Mazzaropi