I want to return info from a specific cell in another sheet, but only if the information relates to another cell (completely different cell)

[1meek1]

I have a sheet where I have 3 people that get different jobs. What I want to do is each time I enter a job on the main sheet, I want it to auto populate under that person’s tab in the workbook. I am able to do it with the =IF (=IF($‘Profitability Tracker’.B3:B999=“Corey B”,$‘Profitability Tracker’.A3,) and it pulls the information correctly, however, it puts the information on the same line that it’s entered on, on the other sheet.

I have three people on the sheet and if someone’s name is before his, it’ll pull their data and put it on the corresponding line on their sheet… Corey’s however will show a zero on that same line in his sheet. Is there a way to get the information to populate on the next line available within the sheet?

Basically, I want the sheet to pull the information and the next time info is entered in the main sheet for Corey I want it to populate on the very next line in his sheet… not line 40 or line 72.

[1meek1]

Basically, I want to pull the information and the next time info is entered for Corey it want it to populate on the very next line… not line 40 or line 72.

[HerCorns]

If I understand correctly you have a “dashboard” where you assign various jobs to 3 people and you would like to keep some form of a log of all the jobs allocated to the 3 individuals? I’m not even sure you can do it in excel, but if you want to do it in calc or any other spreadsheet you’ll most probably going to need some form of a MICRO to take the information and put it in consecutive lines.

I think DataBase would be more suited for what you are trying to achieve.

However, I am interested to learn if there is a method to achieve your desired outcome with formulas.

[mariosv]

Test if the next it’s what you are looking for.

• Column Res.B search for the rows with the ID introduced in Res.B2
• Column Res.C …, gets values in Dat with the same head than in Res.C1 and row number in Res.B2, so more columns can be added copying the formula and only modifying the head as wanted.

SampleConditionalArrayExtractRowsOtherSheet.ods

[1meek1]

Thank you SO MUCH!

[mariosv]

Please, if the answer solves the question click .