Hi all
I am trying to find a value from column C in Columns AC:AE inclusive and if found return the row number of the initial value
for example:
If the value of C2 [DOG] is found in F7 then 2 is returned to A2
Column C will contain unique values
Hope this makes sense - even if the example is pretty pathetic!
<tbody>
</tbody>
I am trying to find a value from column C in Columns AC:AE inclusive and if found return the row number of the initial value
for example:
If the value of C2 [DOG] is found in F7 then 2 is returned to A2
Column C will contain unique values
Hope this makes sense - even if the example is pretty pathetic!
Key | Category | Object | Obj1 | Obj2 | Obj3 |
1 | A | CAT | BALL | BAT | MOON |
2 | A | DOG | STARS | KITE | TABLE |
3 | A | MOUSE | KETTLE | COFFEE | VIOLIN |
2 | B | HAMSTER | DOG | HUTCH | RABBIT |
3 | B | LION | HERO | MOUSE | JUMPER |
1 | B | GIRAFFE | CHAIN | GRAB | CAT |
2 | C | PIG | KEYBOARD | APPLE | DOG |
1 | C | WORM | APRICOT | CAT | DRUMS |
1 | D | SQUIRREL | PHONE | CAT | HOUSE |
<tbody>
</tbody>