| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup w/ AND function
I have a large worksheet and the 1st column is accounts and the 2nd column is
sub accounts, now there are some accounts that are the repeats and some subaccounts that are repeats, but never in the same row. I know how to search using the AND function to find the unique account and subaccount combination, but is there a way to return the value found by this combination? All I am getting is TRUE. SAVE ME Excel Gods!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| Embedded VLOOKUP function within IF function | Excel Worksheet Functions | |||
| HOW DO I NEST THE VLOOKUP FUNCTION WITH THE LEFT FUNCTION | Excel Worksheet Functions | |||
| how do I write a vlookup function within an iserror function so t. | Excel Worksheet Functions | |||
| I want to use Vlookup function and AND function in a single formu. | Excel Worksheet Functions | |||
Threaded Mode
