#16
|
|||
|
|||
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. |
#17
|
|||
|
|||
maby this makes more sense?
if J2 comes up with a error it has to pick the next letter column D |
#18
|
|||
|
|||
But did you actually try the last file I uploaded (Problem_5.xlsx)?
I give uploaded files increasing serial numbers in line with new information. |
#19
|
|||
|
|||
No sorry dident se it
|
#20
|
|||
|
|||
thanks for the patient´s with me.
There is a problem in the last one you send B2 = 75 G2 = 30 dose not come give a result? it should come back H. And i forgot to tell that it has to search in multiple matrix's like in this one i attached. A2 is to select the matrix. |
#21
|
|||
|
|||
Another contribution to this long story.
|
#22
|
|||
|
|||
Very nice
But can you tell me what im doing wrong. I tried to add more matrix's |
#23
|
|||
|
|||
Quote:
If you have problems with this formula (after having read Excel's help on thee used functions) you can ask, but apart from that, this is my final contribution to the thread. |
#24
|
|||
|
|||
Thanks i cant tell you how much this has helped me
|
#25
|
|||
|
|||
It would make sense that B2 = 20 and G2 = 50 but J2 coming back D
|
#26
|
|||
|
|||
Are you MWATKINS7111 the same as who earlier wrote as Diver??
If yes which table _9m, _12m or _15m are you talking about? The only table where I see 70 in column B is _15m and here the corresponding letter to the value 70 is J which result is returned by the formula. |
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 |