|
02-23-2018, 04:14 PM
|
|
Advanced Beginner
|
|
Join Date: Jan 2015
Posts: 32
|
|
Quote:
Originally Posted by NBVC
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
|
THUD.
Excel just cracks me up. I can build up such complicated factors unnecessarily!
Thank you ANGEL. 
|