Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP(lookup_value, ___ ,col_index_num,range_lookup)
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 |