Match & Indirect

  • Thread starter Thread starter ianripping
  • Start date Start date
I

ianripping

Help!

in A1 I have the entry b1:b20

In A2 I hace the equation =match("a",(indirect("a1")),0)

In b2 I have the entry a

Sure A2's equation should display 2? because a is in row number 2?

Whats wrong
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run Macro Upon Entering Data into Cell/s 3
VLookup and Indirect 3
Count cells containing text, multiple criteria 2
INDEX, MATCH, AND OFFSET... OH MY! 4
Matching Data between 2 Tabs on Same Workbook - then calculating 2
Matrix ANALYSIS 1
Evaluate an Array Formula before inserting it in a cell 9
Instr 2

Back
Top