Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

index function not working 1

Status
Not open for further replies.
Chrissirhc

Chrissirhc

Programmer
May 20, 2000
926
GB
Hi,

I want to use Index(A1, 2,1) where A1 contains the name of the range I want to do the index lookup on.

How do I do this?

Thanks in advance,

Chris
 
Sort by date Sort by votes



Hi,

Use the INDIRECT function in this case...
[tt]
Index(INDIRECT(A1), 2,1)
[/tt]

Skip,

[glasses] [red][/red]
[tongue]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Solved
Combine two working macros into one for MS Word 1
Replies
7
Views
1K
strongm
strongm
morechocolate
  • Locked
  • Question
run-tune error 3704 operation is not allowed when the object is codes: I don't think so.
Replies
7
Views
1K
morechocolate
morechocolate
renigar
  • Locked
  • Question
Excel 2010 macro not working in Excel 365
Replies
19
Views
627
RobertPhillips
RobertPhillips
Andrzejek
  • Locked
  • Question
Excel - Function returning Hyperlink 2
Replies
7
Views
1K
Andrzejek
Andrzejek
renigar
  • Locked
  • Question
Macro works correctly on my PC but not on others
Replies
3
Views
453
Markus4
Markus4

Part and Inventory Search

Sponsor

Back
Top