|
|
#12
02-20-2017, 02:36 AM
|
|||
|
|||
B2 = 15 and G2 = 20 then J2 has to come back C
B2 = 20 and G2 = 50 then J2 will come back D B2 = 225 and G2 = 225 then J2 has to come back with a error 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. Example B2 = 50 and G2 = 50 then I2 = 100 but it has to choose 105 from column B or J2 has to choose H from column D 
|
| 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
Threaded Mode