Finding Data and Moving Data From An Adjacent Cell...

  • Thread starter Thread starter QBSat
  • Start date Start date
Q

QBSat

Hi,

I need some help!!

I am trying to get Excel to recongnize specific data in
one cell of the worksheet while taking the value of an
adjacent value.

For instance, using the example below, I am searching for
a particular number (either 6 or 7 in the example below),
but I want to take the information from the cell to the
left of that particular data (either Steven or Tyler next
to their respective numbers). Now, take the data from
either cell in row "A" and place it in an entirely
different cell (let's say C5).

A1 B1 C1

Steven 6
Tyler 7

C5

How can this be done? Any help would be appreciated!!!

Thanks in advance...

QBSat
 
Thanks...this helps greatly!!! One further question...if
I need to index/match multiple names, how can it be done
so that once the first name is moved, then the
spreadsheet will take the next name?

In other words...looking at the example if both Steven
and Tyler have a "6" and I am looking for a "6", how can
both names be moved in a list?

Thanks again....
 
Hi
this is a little bit more complicated. Try the following array formula
(entered with CTRL+SHIFT+ENTER):
Assumption: this formula resides in row 1
=INDEX($A$1:$A$10,SMALL(IF($B$1:$B$10=6,ROW($B$1:$B$10),100),ROW()))
and copy down
 
Back
Top