search, compare, execute based on specified criteria

[jsd219]

I am trying to write a script that looks for a cell with specified text
in a specified column, once it finds the cell it needs to check six
different columns (a,b,c,d,e,f) one row above and find the column that
has an "x", it then needs to place an "x" in its row one column to the
right form the previous "x"

example: if it finds the cell with "Went up the hill" the script needs
to look up one row and check columns (a,b,c,d,e,f) until it finds the
"X".

In this case it will find the "X" on the row with "JACK AND JILL" in
column "a" so it will place an "X" for the row "Went up the hill" (the
orginal cell searched for) in column "b"

a b c d e f g
X JACK AND JILL

Went up the hill

To fetch 3.5 Pales of Water

God bless
jsd219

 

[Don Guillett]

homework?
use the FIND function along with OFFSET

 

[jsd219]

I appreciate that and have been researching it but i am stuck. i can
not figure out how to set a range of multiple columns on a single row
and the row is not a constant. it will change based on the specified
criteria searched for in cells

God bless
jsd219

PS. i live in Austin as well.

 

[Don Guillett]

Send me a workbook with a detailed explanation and I will try to take a
look.
Glad that we have more Austinites around. What do you do ?

 

[jsd219]

I just sent you an email with a sample spreadsheet in it. thank you for
your help.

What do you do ? i own a recording Studio - Music Lane Recording

What about you?

God bless
jsd219

 

[Don Guillett]

I develop excel projects. I will look at your workbook.

 

[jsd219]

Awesome, you rock! i really appreciate it.

God bles
jsd219

PS. my numbers were in the email i sent you in the signature, if you
have any questions feel free to call me. Again thanks