MATCH formula

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

Try

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

Thanks Jonmo1

You're welcome.

Hi

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

Please see the sample workbook attached.

Urgent....

Thanks,
aganesan99

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)

Great!!!!!

Timely help

Thanks,
aganesan99