| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup finding subtotals only
I have the following:
Sheet 1 = Column A = account number (ex. 675000) = lookup_value Sheet 2 = Column A-G subtotaled for Colunm A, by account = Table_array Col_index # is for G (7) My problem, sheet 1 column A is only the account #. How can I have it find in sheet 2 the account subtotals? Its something to do with my sheet 1 account number since it doesnt match the table array €śaccount # total€ť on sheet 2 for the lookup. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup not finding matches | Excel Worksheet Functions | |||
| Finding Cell above Using Vlookup | Excel Worksheet Functions | |||
| Using VLOOKUP after finding LARGE value | Excel Worksheet Functions | |||
| vlookup subtotals value | Excel Discussion (Misc queries) | |||
| subtotals value can be vlookup by another worksheet | Excel Discussion (Misc queries) | |||
Threaded Mode
