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
Quote:
Originally Posted by Excel Dumbo
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
|