| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup alternative
Is there an alternative to vlookup formulas. I have below formulas and trying
to find a way to simplified it. =VLOOKUP($A3,AllData,VLOOKUP(B$2,Sheet3!$A:$B,2,0) ,0) I tried DGET but the problem is that it's only good for single row. I have hundreds of row that use the same formulas. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| alternative to VLOOKUP | Excel Worksheet Functions | |||
| Which is faster? SUMPRODUCT or VLOOKUP, or another alternative? | Excel Worksheet Functions | |||
| Vlookup Alternative Needed | Excel Discussion (Misc queries) | |||
| Nested Vlookup or alternative? | Excel Worksheet Functions | |||
| Alternative to Vlookup/Hlookup to return a value. | Excel Worksheet Functions | |||
Threaded Mode
