INDIRECT and VLOOKUP

[Matt]

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!

 

[John Wilson]

Matt,

What's in B2???

John

 

[Tim Otero]

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!

 

[RSnyder]

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.

 

[Tim Otero]

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!
|
|

 

[EZ Money]

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.