| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLookup VS SumProduct
Was trying to Vlookup two columns on one tab, check it matched the two
columns on current tab and fill in value (Dept # - Acct # - $$$) using Vlookup. Thought I could do it. Ended up using the SumProduct formula that worked but do not understand what the heck it is doing with the "*" in the middle of formula. What was SumProduct doing to bring the correct answer. Prefer using VLookup but could not get two columns to work.. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT or VLOOKUP | Excel Worksheet Functions | |||
| Vlookup, match, or sumproduct? | Excel Worksheet Functions | |||
| do i use vlookup or sumproduct??? | Excel Discussion (Misc queries) | |||
| Sumproduct and Vlookup | Excel Discussion (Misc queries) | |||
| VLOOKUP in SUMPRODUCT array | Excel Worksheet Functions | |||
Threaded Mode
