| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Urgent Dynamic Range with Vlookup
I urgently need to define a formula that execute the following:
I need to do a vlookup on Value 1 to return in the value in column "C" ONLY AND ONLY IF the value in column "B" is "SP". Then I need to do a vlookup on Value 1 to return the value in column "C" ONLY ANLY IF the value in column "B" is "ZA" Value 1 SP 1000035 Value 1 ZA 1000036 -- Regards, Jeff |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic named range across multiple sheets | Excel Discussion (Misc queries) | |||
| Dynamic Range Chart ??? | Charts and Charting in Excel | |||
| how to change range for dynamic chart in excel 2000 with button? | Charts and Charting in Excel | |||
| dynamic range for excel chart | Excel Discussion (Misc queries) | |||
| How do I use Range Names listed in a VLookup table in a formula? | Excel Worksheet Functions | |||
Threaded Mode
