INDIRECT and VLOOKUP

  • Thread starter Thread starter Matt
  • Start date Start date
What is in the cell B2. It should be an exact reference to
a range within an exising workbook.

For example:

B1 formula:
Sheet1!A1

INDIRECT(B2) would use the contents of B1 to determine to
look at Sheet1 cell A1 for what ever value is there.
 
Hi Matt,

A have an example worksheet of this (at least what I think you need)...it's
extremely basic, absolutely no frills. I'll send it to you (and others) if
you email me separately.

tim

| Is the referenced workbook open?
|
| tim
|
| | | Can't seem to make =INDIRECT(B2) to work. Keeps telling
| | me its an error. I have been using
| | www.myweb.cableone.net/twodays/nmdrng.xls to help but
| | don't know where I'm going wrong. Help!
|
|
 
Matt, lets go back to basics: type names in some cells; use cells to the
right of column A. Select the cells and Insert>Name>Define>type MyNames in
the window at the top. the referenced cells should be at the bottom>OK.

let's assume that one of you names is Matt. In a range of cells, type some
characteristics of Matt. Select those cells and insert a name as above,
except name the range Matt.

Now for the payoff:

Select A1 and Data>Validation>Allow>List>=MyNames>OK. Be sure to include the
equal sign (=).

Select A2 and Data>Validation>Allow>List>=INDIRECT(A1).

If you followed the directions and selected Matt in A1, you should see the
Matt characteristics in A2.
 
Back
Top