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.

Attached Files

Problem_5.xlsx (17.0 KB, 11 views)

maby this makes more sense?

if J2 comes up with a error it has to pick the next letter column D

Attached Files

Problem_3 eng.xlsx (12.3 KB, 11 views)

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.

No sorry dident se it

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.

Attached Files

	Problem_3 dk.xlsx (12.3 KB, 8 views)
	Problem_3 eng.xlsx (12.3 KB, 9 views)

Another contribution to this long story.

Attached Files

Problem_6.xlsx (18.5 KB, 7 views)

Very nice

But can you tell me what im doing wrong. I tried to add more matrix's

Attached Files

Problem_7.xlsx (13.3 KB, 8 views)

No, I don't feel up to deciphering this monster formula. Instead I have made a new one.

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.

Attached Files

Problem_8.xlsx (19.4 KB, 9 views)

Thanks i cant tell you how much this has helped me

It would make sense that B2 = 20 and G2 = 50 but J2 coming back D

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.