If-format problem

P

puiuluipui

Hi, i have this code that retrieve : Rate 1, or Rate 2.....from E6:Q6 if
there is something in E8:Q8. The code is working ok, if in E8:Q8 is something
like this(584.01.10.2009). I need this code to work if in E8:Q8 is something
like this (584/01.10.2009)

=IF(rate!E8="",rate!E6,IF(INDEX(rate!E6:Q6,MATCH(9^9,rate!E8:Q8)+1)="","No
more rates",INDEX(rate!E6:Q6,MATCH(9^9,rate!E8:Q8)+1)))

Can this be done?
Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top