View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Phillip[_5_] Phillip[_5_] is offline
external usenet poster
 
Posts: 33
Default Formula using INDIRECT function?


Phillip London UK

Matches the first occurrence of "Low" in Sheet named Belgium in column
A
and returns the value in column H in the matched row

So if Belgium!A3 contains "Low" then value of H3 is returned from the
sheet
where the formula is entered

If H3 contains an error value than formula returns 0