Help Wanted With VLOOKUP

[asw301]

I have inherited a data sheet that I am trying to get my head around. Am stuck on the function below, specifically what _LMM1 refers to, its not a tab in the sheet (unless its hidden and cant be retrieved), any ideas?
many thanks



=VLOOKUP($A153,_LMM1,VLOOKUP(D$151,$B$232:$C$258,2,FALSE),FALSE)

[Jakobshavn]

It is probably a Named Range.

[asw301]

that would make sense - is there anyway to work backwards to find out where it sits?

[greggy99]

_LMM1 refers to a Range...example A1:B3

just ctrl+f3 to see ranges that have been set...

if its hidden just change the visible property of a sheet in developer tab...
visual basic >property>visible>visible

[jake.masters]

It looks like it is a data range within the worksheet. If you are using 2007/2010, go to the name box to the left of the formula bar and click the down arrow. This should show you a list of named objects.

[asw301]

thanks all will get back to you if not resolved! many thx