O
odie
I would like to define a named range = vlookup("2", range1,3,false).
Whenever I try this, vlookup only returns the first match in range1, not the
other match occurances. I have tried entering as an array formula but it
only returns the first match. I admit I may be confused between ranges and
arrays.
Could someone please help? thanks...
Whenever I try this, vlookup only returns the first match in range1, not the
other match occurances. I have tried entering as an array formula but it
only returns the first match. I admit I may be confused between ranges and
arrays.
Could someone please help? thanks...