Value match in a table plus formula?

		Microsoft Office Forums > Microsoft Excel > Excel
Value match in a table plus formula?

02-23-2018, 04:14 PM

Chancy

Windows 7 64bit Value match in a table plus formula?

Office 2010 64bit

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.

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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:12 PM.