The heart of it is this part

INDIRECT(U61&$V$61&MATCH($B$60,INDIRECT(U61&"A:A") ,0))

which is searching column A on the worksheet pointed to by U61
(INDIRECT(U61&"A:A")) for the value obtained from B60
(MATCH($B$60,INDIRECT(U61&"A:A"),0)), which presumabnly returna a row
number, and concatenating that with V61 to get a cell reference,
concatenating that with B61 to get a cell in a worksheet reference, and then
using INDIRECT to lookup the value pointed to by that cell.

The rest just checks if it is an error, so as to keep it neat and tidy.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Louise" wrote in message
...
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,