Home |
Search |
Today's Posts |
#1
|
|||
|
|||
vlookup
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) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array Function with VLOOKUP | Excel Worksheet Functions | |||
make a vlookup using a variable path | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
VLOOKUP not working | Excel Worksheet Functions |