View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Louise Louise is offline
external usenet poster
 
Posts: 217
Default Formula using INDIRECT function?

Hi,

Can someone help me translate the following formula?

=VALUE(IF(ISERROR(INDIRECT(U61&$V$61&MATCH($B$60,I NDIRECT(U61&"A:A"),0))),0,INDIRECT(U61&$V$61&MATCH ($B$60,INDIRECT(U61&"A:A"),0))))

U61 = Belgium!
V61 = h
B60 = Low

If I can understand what it means I may be able to work out what is going on
on a very complicated spreadsheet i have inherited...


Thanks,