Find specific value in a row, based on another value in the row

**Anna1992** · 01-31-2017, 05:41 AM

Hello everybody!

Ive got a problem which I think is not super difficult to solve. However, Im failing to solve it tough Im desperate to find the solution.

The situation:
ID First name Last name First name Last name First name Last name First name Last name
A. Mia Smith David Miller Logan Jackson
B. Avery Johnson Elizabeth Davis Oliver Thomas Joseph Lee
C. Chloe Williams Sofia garcia
D. Daniel Brown Ella Wilson David Sanchez
E. Lucas Jones

I want to find the ID of Miller (ID A.) and Sanchez (ID D.).

Does someone has any suggestions?

**Richard Buttrey** · 01-31-2017, 06:08 AM

Hi and welcome to the forum

Here's one approach which uses a helper column to identify which column contains the name in question and then a helper cell to identify the row that contains the name

Find specific value in a row, based on another value in the row

LinkBack

Thread Tools

Rate This Thread

Display

Find specific value in a row, based on another value in the row

Re: Find specific value in a row, based on another value in the row

Thread Information

Users Browsing this Thread

Similar Threads

Find value based on specific text demands

[SOLVED] Find specific values based on two conditions

[SOLVED] How to find specific value in row based on multiple lists options

[SOLVED] Find specific file based on day of the week

[SOLVED] Formula to find the sum of a set of data based on specific criteria

Need to find a specific row based on matching 3 columns

[SOLVED] Find and Replace Macro Based on Specific Cells

Bookmarks

Bookmarks

Posting Permissions