return the row number when a match is found

[MartinL]

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!

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>

 

[alansidman]

Your explanation in relation to your visual example makes no sense. Suggest you retry. You talk of searching AC:AE. Your example finds Dog in Column F. Why a two if the row is 7. Very confusing request.

 

[MartinL]

Your explanation in relation to your visual example makes no sense. You talk of searching AC:AE. Your example finds Dog in Column F. Why a two if the row is 7. Very confusing request.

So, In my real sheet I am looking at Columns AC:AE
In my Example this has become Columns D:F [I should have checked that-oops]

So what ever I find in D:F will only ever be found in category A which in my example only has 3 objects
Therefore what I am trying to do is say when you find DOG in D:F locate it in C and return the row number of C in A where n is the Current row number

Therefore in my example the active row is 7 and DOG is found in F7
In Category A DOG is found in Row 2
so in A7 (the row containing DOG in F7) we input the Value 2 because DOG is found in C2

The values in Column C are all unique but the values in Column D, E & F are not