Hi Kevin,

THanks for your reply. I am using Excel 2003. You are using the formula that will be suiting the advanced excel version. Could you please suggesta formula for Excel 2003. I am sorry I should have pointed this out earlier.


Regards,
Excel Dumbo

Hi Excel Dumbo

Then you just need to replace the IFERROR with IF & ISERROR.

=IF(ISERROR(INDEX(INDIRECT($C2),MATCH($A2,$A$34:$A $45,0),MATCH($B2,$E$34:$P$34,0))),"",INDEX(INDIREC T($C2),MATCH($A2,$A$34:$A$45,0),MATCH($B2,$E$34:$P $34,0)))

I would upload a xls file, but you cannot upload anything on this site and it is a waste of time using the "Contact Us" in the link at the bottom of the page as they don't bother to reply!!!

Kevin

Thanks Kevin for your solution