|
|
|
|
#1
02-20-2017, 03:16 AM
|
|||
|
|||
The problem for me is that sometimes B2+G2 = I2. I2 dose not always come back with a match for column B. So it has to chose a number higher from column B.
I have made the B2 and G2 lists. so that only the right number can be selected. 
|
|
#2
02-20-2017, 04:01 AM
|
|||
|
|||
|
So you had not tried what I sent you in #11 which was based on column G instead of B as it was before #14 where you wrote:
If B2+G2 does not come back as a number that exists in column B. it has to choose a number higher than it self in column B.
|
|
| Tags |
| match, sumif, vlookup |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Matrix allignment
|
Lima | Word | 2 | 02-06-2017 03:11 AM |
|
Row and Column name in matrix
|
ankush | Word | 1 | 07-21-2015 03:39 AM |
| How to get value through a matrix? | Xemx | Excel | 3 | 10-21-2014 05:46 AM |
|
Dot Matrix Printing
|
Angela | Office | 2 | 05-15-2012 08:56 PM |
| Matrix Algebra | judicial85 | Excel | 3 | 10-12-2011 05:41 PM |
Windows 10 
Office 2013
Hybrid Mode