Range

  • Thread starter Thread starter Robert Dieckmann
  • Start date Start date
R

Robert Dieckmann

I'm working with Excel 2000 and can't seem to do what I want to do with
ranges. Let's say I have 3 ranges - B4:D6 is named HTT15; B9:D11 is named
HTT18; and B14:D16 is named HTT21. The content of these cells is
inconsequential to my question. Which range I use in my formula is
dependant upon the last two characters, e.g. 15, 18 or 21 in my example.
This number is listed in cell A1. I have a formula in cell A2 that
concatenates the HTT with the number [="HTT"&A1]. If cell A1 contains the
number 15 then the result in A2 is HTT15. So far, so good. All I want to
do is a simple vlookup function that uses the range as defined in cell A2,
which is dependant upon the value in cell A1. I have tried to do two
approaches. The first formula is [=VLOOKUP(3,A2,2)]. This results in #N/A
(I'm assuming that it is trying to read cell A2 as the range, rather than
the contents of cell A2). My second approach was to include the formula
within the vlookup function as [=VLOOKUP(3,"HTT"&A1,2]. This results in
#VALUE!. This seems fairly straightforward, but I'm obviously missing
something. Thanks in advance for any suggestions.

Robert
 
Back
Top