Tab issue

jerry8989

New Member
Joined
Nov 19, 2003
Messages
43
I have a column that has tracking numbers. Each of those numbers has a tab that has the exact name as the tracking number. I need to create a formula that will allow me to use the value in the tracking number cell to reference a cell in that tracking numbers tab.

EX.
Tracking Number(Main - Col M), Date(Col N,sheet value depends on Col M)
[M1] DD-0250-2102-03, M1!A1, so I want it to be DD-0250-2102-03!A1
[M2] XX-3642-2402-03,
[M3] FF-5159-2402-03

I hope this makes senses. I pretty much need to use a cell value in my main tab as the tab name so I can get values out of those tabs.
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Watch MrExcel Video

Forum statistics

Threads
1,114,051
Messages
5,545,724
Members
410,702
Latest member
clizama18
Top