Thread: Value match in a table plus formula?
View Single Post
 
Old 02-23-2018, 12:07 PM
NBVC's Avatar
NBVC NBVC is offline Windows 10 Office 2013
The Formula Guy
  
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default
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
Reply With Quote