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
|