Thanks Carim,

this is the formula i've got, tried inserting the iserror you gave but
got an error.
=IF(B3="","",MAX((Shed!$B$3:$E$46=B3)*(ROW($1:$44) ))&CHOOSE(MAX((Shed!$B$3:$E$46=B3)*(COLUMN(Shed!$B $3:$E$46))),"","D","C","B","A"))

Hope this may give you some idea.

Regards

David


--
dgraham
------------------------------------------------------------------------
dgraham's Profile: http://www.excelforum.com/member.php...o&userid=33138
View this thread: http://www.excelforum.com/showthread...hreadid=531161