Value match in a table plus formula?

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

02-23-2018, 05:10 PM

Chancy

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

Office 2010 64bit

Advanced Beginner

Join Date: Jan 2015

Posts: 32

FYI, This is what I currently have:

Code:

=ROUND(IFERROR(VLOOKUP(VALUE(P1398),FEE!$A$4:$B$118,2,0),VLOOKUP(TEXT(P1398,0),FEE!$A$4:$B$118,2,0))*(J1398),2)

Delighted to find that even for the entries that multiply times zero, the results are zero (not #N/A or #DIV).

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 07:26 AM.