Hi, Is it possible to create a function that uses the value of a field
as a pointer for another row

this is what I want
no-A-B
1-3-blaat
2- -booh
3-1-test

should become
no-A-B-C
1-3-blaat-test (since A=3 and B3 is test I need the value of B3)
2- -booh- (empty since A2=empty)
3-1-test-blaat (since A=1 and A1=blaat I need the value of B1)

Floortje


--
floortje
------------------------------------------------------------------------
floortje's Profile: http://www.excelforum.com/member.php...o&userid=23968
View this thread: http://www.excelforum.com/showthread...hreadid=375896

In C1, enter the following:
=IF(ISERR(INDIRECT("B"&A1)),"",INDIRECT("B"&A1))

and copy down.

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=375896

Great !! Even more help then I was hoping for !! Thx verry much

Floortje


--
floortje
------------------------------------------------------------------------
floortje's Profile: http://www.excelforum.com/member.php...o&userid=23968
View this thread: http://www.excelforum.com/showthread...hreadid=375896

Thanks for the feedback.

Mangesh

Great !! Even more help then I was hoping for !! Thx verry much


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=375896