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.

Compare values in two columns and return the value from third
Display two columns in data validation list but return only one - Guide
Wow equipment return ✓ - Network Forum
Flipkart return comments - Guide
Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
Beyond compare - Download - File management

1 response

Answer 1 / 1

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 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

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.

Similar discussions

help me to add particular cells

Compare values in two columns and return the value from third

Excel - IF function with multiple words

If cell = date return yes or no.

Comparing columns and returning value

Similar discussions

Subscribe To Our Newsletter!