I have four separate formulas that work correctly, I need to combine these formulas into one. Currently using VLOOKUP to check my value against another workbook in sheet 1, another formula using VLOOKUP to check my value in another workbook in sheet 2, sheet 3, and sheet 4.
Solved by A. A. in 18 mins