T
TPratt
Is there a way to use a vlookup to look across multiple tabs within an excel
file?
Example
Tab 1 contains sales data from salesmen in State A
Salesman Sales
1 100
2 200
3 500
Tab 2 contains sales data from salesmen in State B
Salesman Sales
5 1000
6 600
7 800
From another tab, I would like to be able to type in a salesman's number and
get their sales, regardless of which tab they're on, without having to first
combine the data onto one sheet.
* The data is in the exact same place on each tab. (ie. Salesman 1 and
Salesman 5 are each in Cell A2 on their respective tabs)
file?
Example
Tab 1 contains sales data from salesmen in State A
Salesman Sales
1 100
2 200
3 500
Tab 2 contains sales data from salesmen in State B
Salesman Sales
5 1000
6 600
7 800
From another tab, I would like to be able to type in a salesman's number and
get their sales, regardless of which tab they're on, without having to first
combine the data onto one sheet.
* The data is in the exact same place on each tab. (ie. Salesman 1 and
Salesman 5 are each in Cell A2 on their respective tabs)