Help with IF(INDEX(MATCH

@Paul Newcome yes sir, only one cell in the Task Name column would contain "First Customer Event", the problem is there needs to be additional qualifying language in the cell after that prefix to identify what that event actually was and it's going to differ from sheet to sheet.

@Paul Newcome thanks! Sorry for additional questions but what is the @cell piece of the formula above? Is that an individual cell link

That cell is not going to be in the same row on each sheet, it's going to vary across the board so i can't reference a single cell and keep that formula consistent across the entire data set.

Also, don't i need to include a MATCH to return the corresponding cell in column Start Date?

Thanks @Paul Newcome !

I'm getting INVALID, may be because BNYTask and BNYTaskName are the same column. Here's a screen shot that may help.

Wasn't sure which column you were referencing when you used BNYTask and BNYTaskName.

Columns needed to reference in formula are TaskName, Completion, Start

Also, the cell that now reads "Customer Pitch" in column "Task Name" will be where I change it to "First Customer Event - Customer Pitch"

I owe you a beer :)

It worked! My man @Paul Newcome! 🍻

Last question until next week - is there a quicker way to link individual cells rather than using the cell linking button for individual cells.

If I'm inputting data onto one sheet but want that to be separate from where i'm doing formulas on that data for quality control purposes, is there a way to get that data into the formula sheet without having to individually link each cell.

Intent is to automate the transfer of the data within the cells from the input sheet to the formula sheet.

@Paul Newcome, hope you have been well. Next issue I'm facing -

I've created a series of sheets who's purpose is to provide a "Top 10" list for certain metrics. So my source sheet contains a column who's contents are all whole numbers (many instances of the same number). The formula I've written to return the 10 largest numbers in the column, and then corresponding customer name is as follows:

=IFERROR(LARGE(COLLECT({TimeinContracting}, {Status}, {Status} = "Active"), 1), "-")

=IFERROR(LARGE(COLLECT({TimeinContracting}, {Status}, {Status} = "Active"), 2), "-")

=IFERROR(LARGE(COLLECT({TimeinContracting}, {Status}, {Status} = "Active"), 3), "-")

=IFERROR(LARGE(COLLECT({TimeinContracting}, {Status}, {Status} = "Active"), 4), "-")

=IFERROR(LARGE(COLLECT({TimeinContracting}, {Status}, {Status} = "Active"), 5), "-")

so on until...

=IFERROR(LARGE(COLLECT({TimeinContracting}, {Status}, {Status} = "Active"), 10), "-")

The problem is that when there is more than one customer with the same number in column {TimeinContracting}, my formula that returns the associated customer name just returns the first customer name in the column that matches that number - so in some cases I have the same customer listed more than once because my formula found that customer name first and returned it a second, third, fourth, fifth time even though there were 4 other customer names associated with the same number in column {TimeinContracting}.

Here's the formula i'm using to match customer name to the number that the formulas above return:

=IFERROR(INDEX({Customer}, MATCH([Time in Contracting]1, {TimeinContracting}, 0)), "-")

Screenshots:

So the first formulas I referenced above are in column Time in Contracting and the second formula is in column Customer.

I need to find a way to return the actual associated customer name from the source sheet, rather than just the first customer name that matches the value in Time in Contracting on the source sheet because I will have the same number for many of these metrics. All of these are going into reports I've built.