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!
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!