Formula to look Column A and Column C and place Desired Outcome in Column E

**bjnockle** · 03-20-2021, 10:38 PM

Looking for formula (preferably non-array) to look into Column A and Column C and place Desired Outcome in Column E. See attached sample file.

Thanks.

**Bo_Ry** · 03-20-2021, 11:22 PM

Please try at E2
=INDEX(D$2:D$7,MATCH(C2,INDEX(REPT(C$2:C$7,ROW(C$2:C$7)<>ROW(C2)),),))

Formula to look Column A and Column C and place Desired Outcome in Column E

LinkBack

Thread Tools

Rate This Thread

Display

Formula to look Column A and Column C and place Desired Outcome in Column E

Re: Formula to look Column A and Column C and place Desired Outcome in Column E

Thread Information

Users Browsing this Thread

Similar Threads

Extract Values in Column S into Column R (Desired Output Column)

Place values (0s and 1s) into desired columns (column L,M,N and O)

Place values into desired results column based using Status heading in column E

Place values into desired results column based on year & names

Is there a way to compare data of column 1 with column 3 and place it next to column 1?

[SOLVED] need formula to this logic, A column number B column blank then C column desired name

data in 2 column and display the desired result in 3rd column

Bookmarks

Bookmarks

Posting Permissions