Looking for a formula to find the postion of a value anywhere in an array

[PLeeY3]

Hello,

I'm looking for an array to find the placement of a value, in this case a word, that doesn't appear in the same column or row. Basically I'm running from a clients server and they're not all the same so the row and/or the column varies between various clients.

I also don't need the cell location per se, I can just add one to the column index to get the value I need.

Currently I'm pulling the data in sheet 2 and then on sheet 3 I use and a match formula in columns A-F and rows 1-6. This finds the location but is starting to get messy and I was hoping to condense the various rows/columns into a single cell.

I'm looking for CPU cores:

Client A has this value on row 7 column 9
Client B has this value on row 34 column 10

Please let me know if there is any confusion over the request.

 

[Andrew Poulsom]

Is this the sort of thing you want?

Excel 2010
	A	B	C	D	E	F	G
1		Col1	Col2	Col3	Col4	GHI	LMN
2	Row1	ABC	FGH	KLM	PQR
3	Row2	BCD	GHI	LMN	QRS
4	Row3	CDE	HIJ	MNO	RST
5	Row4	DEF	IJK	NOP	STU
6	Row5	EFG	JKL	OPQ	TUV
Sheet1

Cell Formulas
Range	Formula
G1	=INDEX(B2:E6,MAX(INDEX((B2:E6=F1)*(ROW(B2:E6)-ROW(B2)+1),)),MAX(INDEX((B2:E6=F1)*(COLUMN(B2:E6)-COLUMN(B2)+1),))+1)

 

[PLeeY3]

Perfect, thank you.