MATCH formula

[aganesan99]

Hi,

I am using MATCH function to match a value in a different tab.

I have attached a sample file.

Please help on this. Its urgent.

Thanks,
aganesan99

[Jonmo1]

Try

=MATCH(B2,INDIRECT(A2&"!A:A"),0)

[aganesan99]

Thanks Jonmo1

[Jonmo1]

You're welcome.

[aganesan99]

Hi

When I changed the tab names to Numbers, the formula is showing REF.

Please see the sample workbook attached.

Urgent....

Thanks,
aganesan99

[Jonmo1]

That's not a number, it's a text string
1 period space 223

If the tab name contains a space, then any references to that tab must be enclosed in apostraphes

'1. 223'!A:A

Try
=MATCH(B2,INDIRECT("'"&A2&"'!$A:$A"),0)

[Tony Valko]

In the INDIRECT function use single quotes like this:

INDIRECT("'"&A2&"'!A:A")

In "exploded view":

INDIRECT(" ' " & A2 & " ' ! A:A ")

[aganesan99]

Great!!!!!

Timely help

Thanks,
aganesan99

[arlu1201]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.