|
|
#6
02-23-2018, 12:07 PM
|
||||
|
||||
If your formula gives you a correct result, then you just need to add the multiplication...
Code:
=IFERROR(VLOOKUP(VALUE(B2),Codes!$A$1:$B$30,2,0),VLOOKUP(TEXT(B2,0),Codes!$A$1:$B$30,2,0))*A2 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Formula that looks at more than one criteria and then adds up those that match
|
DazzyBee | Excel | 2 | 01-20-2017 11:29 PM |
| index / match Formula | dmcg9760 | Excel Programming | 1 | 11-08-2015 03:16 PM |
| Complex Formula using INDEX and Match needed | OTPM | Excel | 5 | 05-23-2013 01:22 AM |
| Help with multiple match and index formula | ryanwood | Excel | 1 | 09-12-2012 07:53 AM |
| Need another formula to match my last one | tinkertron | Excel | 2 | 04-29-2009 02:17 PM |
Windows 10 
Office 2013
Threaded Mode