formula for matching a name to a number

[tonylpcs@yahoo.co.uk]

Hi everyone,

ive need formula that can look along row 4 from B4 to H5 and find the line that has the same value as 4A in it and get it to = the cell above it?

in otherwords i want the formula that says this:

find the cell in line B4 to H5 that = A4 and enter in this cell the value of the cell directly above it i.e. if its cell D4 then this cell = D3

anyone able to help

thanks

tony

 

[snoopyhr]

maybe something like this?

Excel Workbook
	A	B	C	D	E	F	G	H	I
3	Upper row	Is	the	result	For Value Above	the	match	found?	Result
4	Check	This	is	the	check	for	look	up	For Value Above
5	upper row 2	Here	is the	another	example	for	this	condition	Result
6	This	This	is	the	check	for	look	up	Here
Sheet2

 

[tonylpcs@yahoo.co.uk]

thank you thats perfect.

thanks

Tony

 

[snoopyhr]

Welcome, glad I could help