Microsoft Office Forums - View Single Post - [Solved] 2nd matrix gives a resut that doesn´t match numbers in the 1st matrix

Thread: [Solved] 2nd matrix gives a resut that doesn´t match numbers in the 1st matrix

View Single Post

Old

02-20-2017, 03:16 AM

Diver

Diver is offline

Diver uses Windows 10

Windows 10 Diver uses Office 2013

Diver uses Office 2013

Office 2013

Novice

The original poster

Join Date: Feb 2017

Posts: 21

Diver is on a distinguished road

Default

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.

Attached Files

Problem_2.xlsx (10.9 KB, 9 views)

Reply With Quote