Formula to check combinations of values in one column to find match from another column

		Microsoft Office Forums > Microsoft Excel > Excel
Formula to check combinations of values in one column to find match from another column

06-15-2018, 05:26 AM

NBVC

Windows 10 Formula to check combinations of values in one column to find match from another column

Office 2013

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

Try adding helper columns that sum the two columnns. Then use those for your matching...

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Is it possible to put a formula in a table column header to define the name of the column?	JacquesW	Excel	3	05-08-2017 08:00 AM
Overwriting values in formula controlled column	Guloluseus	Project	3	01-09-2017 05:58 PM
What formula can I use to find the lowest cell in a column that has a value in it?	EddyWD	Excel	3	04-20-2016 09:29 PM
Formula/function to return column names for matching values	GiJoe81	Excel	1	06-27-2015 12:13 AM
adding up from another column after match	MorriSiege	Excel	0	04-28-2015 09:13 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:11 PM.