Sign in to join the conversation:
Hi, I have successfully setup an index/match with 1 sheet but I need to add a 2nd sheet for the index to search as well. How would I set this up in the formula? I tried to notate both sheet's columns for the range but keep getting an error.
Thanks
Could you post some screenshots so we can see what exactly you are working with?
Awesome! That totally worked!
Thanks everyone for all your help.
?!?
I am trying to get the passenger count per month per year, and I can't seem to get the formula correct. I need to add the number of passengers for each month per year. If anyone could assist me with this, I would greatly appreciate it. Thanks!
I need to edit a large sheet that has a lot of predecessors. I need to delete one row and move another. when I make the changes the predecessors for proceeding lines are not correctly displaying the dates correctly. Need help.
Hi all, I'm having some issues with an index-collect formula. I have (3) existing sheets that list a unique project name (text field), as well as a producer assigned to work that project. The producer column in all (3) sheets is set as a contact field. In a separate sheet, I'm trying to auto-populate the producer…
