Hi,

I am trying to write a match function using an indirect range reference (cell D5 contains the name of the range):

(MATCH(G12,INDIRECT($D$5),-1)

Match type 0 and type -1 work fine, but I need match type 1 (pick the largest value that's less than or equal to G12), which returns #N/A on the whole function when I try it now (the match is embedded in an hlookup).

Thanks for your help!