Previous Topic Next Topic

Compare values in two columns and return the value from third

Closed
jtliapp Posts 2 Registration date Friday 12 January 2018 Status Member Last seen 26 January 2018 - 12 Jan 2018 à 23:47
jtliapp Posts 2 Registration date Friday 12 January 2018 Status Member Last seen 26 January 2018 - 26 Jan 2018 à 17:33
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.
Related:

1 response

Réponse 1 / 1
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
13 Jan 2018 à 07:25
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
jtliapp Posts 2 Registration date Friday 12 January 2018 Status Member Last seen 26 January 2018
26 Jan 2018 à 17:33
Thank you for your help! It did not work.

Similar discussions

WOW equipment return
aakash12345_0667 -
HelpiOS -

1 response