Using excel app on iPad
I’m trying to enter a breakout sheet in my first tab. Then I have sheets made up for every different employee, those sheets have formula to pull their assigned aisle information if the name cell is found in the range on the first tab.
The problem I’m running into is if they only have 1-3 aisles assigned to them the formula will still return the next aisle. I know this is because I have it mainly adding 1. I’m just not sure how to have it only go through the range with how large the merged cell is. I.e.: Colton has 3 cells, I want it to only fill 3 cells worth.
The end goal is so that anyone can just enter the truck breakdown on the first sheet and it will auto fill the corresponding sheets to the employee names. I don’t even care if it returns “#REF!” because I can look past that with a sumif formula. this is the formula I’m currently using to return the correct values:
=INDEX('Consumables Breakout'!B5:B20,MATCH(E3,'Consumables Breakout'!I5:I20,0))
=INDEX('Consumables Breakout'!B5:B20,MATCH(E3,'Consumables Breakout'!I5:I20,0)+1)
=INDEX('Consumables Breakout'!B5:B20,MATCH(E3,'Consumables Breakout'!I5:I20,0)+2)
=INDEX('Consumables Breakout'!B5:B20,MATCH(E3,'Consumables Breakout'!I5:I20,0)+3)
Bookmarks