VLOOKUP(lookup_value, ___ ,col_index_num,range_lookup)
Hi Ricky,
Look in HELP for the INDIRECT() function
--
Kind regards,
Niek Otten
"RICKY" wrote in message ...
I built 2 named range for search, for example,
"ABC" = A1: D4
"DEF" = A10: F10:
and let's say, if Z1 = 1 then A100 = "ABC" and
if Z1 = 2 then A100 = "DEF"
how can have VLOOKUP to look for range ABC or range DEF based on contains in
A100?
Ricky
|