finding information

[klatlap]

hi all...can i use the formula to find information in a row between two cell references and what would i need to add.

thanks
=Mid(A2,Find(“-“,A2)+1,2)

 

[tmischler]

can you elaborate a little, I am not sure I understand what exactly you want to do?

 

[klatlap]

Re: finfing information

WEIGHT SELECTION.xls
	O	P	Q	R
263
264	Heavy:	0:0-0-0.	First	Up:
265	Cd	50.00	-3.00	-53.00
266	8.00	Cd	51.50	-3.00
267	2.00	Cd	52.00	-3.00
RATING

The information i need to extract is in cells P265/Q266/Q267 now the cells that this information appears in can change so i wanted to find the Cd that appears always in the cell before the information i want....how best can i do this

 

[tmischler]

how many columns is it possible for the "cd" to be in?

 

[fairwinds]

Hi,

Try:

=INDEX(O265:R265,MATCH("cd",O265:R265,0)+1)

 

[klatlap]

Ok that seams to work...yes the Cd only apears in the row once like that.....will be adding this to my list of ever growing formulas for later reference....thanks again