Move value of a cell into another cell if multiple criteria is match in multiple ranges

[zlinksystems]

Hello Excel Pros, I am trying to move a the value in "REMAINING DRAWS" column to the "AMOUNT SUBMITTED" column if LItem and Lev and Sec is equal to the values in LEVEL, SECTION, AND LINE ITEM DESCRIPTION columns. When that is accomplished the LItem and Lev and Sec variable values will change and the search will continue again to move the value again. I am stumped on what I feel is something simple.

Please Login or Register  to view this content.

PROJECT | LEVEL | SECTION | LINE ITEM DESCRIPTION | AMOUNT PAID | DATE PAID | AMOUNT SUBMITTED | DATE TURNED IN | REMAINING DRAWS

Villas of Canterfield 1 A LAYOUT
Villas of Canterfield 1 A WALL FRAMING
Villas of Canterfield 1 A EXTERIOR SHEATHING
Villas of Canterfield 1 A FLOOR TRUSSES
Villas of Canterfield 1 A FLOOR DECKING
Villas of Canterfield 1 A PUNCHOUT
Villas of Canterfield 1 A FURDOWNS / BULKHEADS
Villas of Canterfield 1 A CORNICE EAVE, FACIA, TRIM, SIDING
Villas of Canterfield 1 A HOLD DOWNS AND HARDWARE
Villas of Canterfield 1 A SET WINDOWS
Villas of Canterfield 1 B LAYOUT
Villas of Canterfield 1 B WALL FRAMING
Villas of Canterfield 1 B EXTERIOR SHEATHING
Villas of Canterfield 1 B FLOOR TRUSSES
Villas of Canterfield 1 C FLOOR DECKING
Villas of Canterfield 1 C PUNCHOUT
Villas of Canterfield 1 C FURDOWNS / BULKHEADS
Villas of Canterfield 1 C CORNICE EAVE, FACIA, TRIM, SIDING

[xladept]

Hi zlinksystems,

Welcome to the Forum!

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic