Hi!

Assume this data is in Sheet1 A1:D4

Row 1 are the headers:

Foundation ----------- cost 1 -----------cost 2

Column D contains the "X".

On another sheet, say, in A1, enter this formula and copy across to C1:

=INDEX(Sheet1!A2:A4,MATCH("X",Sheet1!$D2:$D4,0))

Biff

"Yin" wrote in message
...
I have a spreadsheet that contain data by category. Example:

Foundation ----------- cost 1 -----------cost 2
Foundation - guy 1 ---- $100 ---------- $150
Foundation - guy 2 ---- $120 ---------- $160 -- X
Foundation - guy 3 --- $130 ---------- $190

If I put an "X" or maybe "highlight" on column Foundation - guy2 for
example, I would like to populate his information to a different sheet.

Do you know how to go about it?