Simplify a Formula

Cristina Andersen

No. Im making a helper column...so we have 30 conveyors spread throughout three areas. I'd like to have a formula that says which plant each conveyor belongs in, which will then be used in a sheet summary to say...so many conveyors in area 1, 2, and 3 have been inspected...

Paul Newcome

"I'd like to have a formula that says which plant each conveyor belongs in"

What is the logic that determines this? Do you have a master list of all conveyors and where they belong, or is there some type of indicator elsewhere on the sheet?

Cristina Andersen

Paul, Its a master list that I have on a spreadsheet.

Cristina Andersen

Paul, should I make a Helper sheet and then Vlookup......

Paul Newcome

If you already have a master list of all of the conveyers and where they should be located, then you can use a VLOOKUP to reference the table. I personally prefer INDEX/MATCH as it references (potentially) fewer cells and holds up better to adjustments in the source data layout.

=INDEX({Master List Location Column}, MATCH(Conveyer@row, {Master List Conveyer Column, 0))