Show sheet based on serial number

[sujittalukde]

I am making an excel file wherein a macro is needed which will show only one sheet based on the data of the serial number and pick the data corresponding to that serial number.

A sample file is attached which will clarify more.

[Bob Phillips]

No VBA!

[sujittalukde]

Thanks xld, one question Can I use VLOOKUP formula to get the result? If yes which one will be better - VLLOKUP or INDEX formula?

[Bob Phillips]

Yes, it will work just as well. As to which is better, the INDEX will be faster, but so negligible as to be irrelevant), but if you prefer VLOOUP, switch to that.

[sujittalukde]

Thanks I asked it for my knowledge only.