]]>

I'm looking to add formulas to my spreadsheet that can index/match across multiple tabs, and return:

1) Match

2) Next cell beyond the match

3) The previous cell that isn't empty

Below is the Sheet I'm working on. The Info Tab needs to update who…]]>

I'm looking to add formulas to my spreadsheet that can index/match across multiple tabs, and return:

1) Match

2) Next cell beyond the match

3) The previous cell that isn't empty

Below is the Sheet I'm working on. The Info Tab needs to update who the Next Runner is, what time they start, who the second runner is, the time they start, and what time the current runner started.

Thanks again!]]>

Apologies for the delay in getting back. Just wanted to say thanks for the response - it worked perfectly! Only tweak I needed to make was "" to " ".

Thanks again!

]]>What has happened was when I change from sheet to sheet (while writing the formula), the sheet mentioned in the formula is auto changed by the computer. I noticed it lately. When i change the…]]>

What has happened was when I change from sheet to sheet (while writing the formula), the sheet mentioned in the formula is auto changed by the computer. I noticed it lately. When i change the sheet name in the formula manually , vlookup works correctly.

]]>Your solution is not the answer.... I don't need to know Why .... I need a solution to get the link fixed, without changing every formula (Or Hyperlink).

I need to know if there is another way to fix this....

Thank you in advance for your help...…]]>

Your solution is not the answer.... I don't need to know Why .... I need a solution to get the link fixed, without changing every formula (Or Hyperlink).

I need to know if there is another way to fix this....

Thank you in advance for your help... (and about the forum and my misbehave so sorry.... still learning the way.... thank you for your help and comments).

]]>=Trim(Left(G2,Search(" at ",G4&" at ")-2))

Do you get the entire cell returned?

If you can you please supply a sample workbook?]]>

What happens if you try

=Trim(Left(G2,Search(" at ",G4&" at ")-2))

Do you get the entire cell returned?

If you can you please supply a sample workbook?

]]>=FILTER(A2:A10,(B2:B10=G1)*(C2:C10<>""))

or

=IFERROR(INDEX($A$2:$A$10,AGGREGATE(15,6,(ROW($A$2:$A$10)-ROW($A$2)+1)/(($B$2:$B$10=$G$1)*($C$2:$C$10<>"")),ROWS(G$2:G2))),"")]]>

In that case try

=FILTER(A2:A10,(B2:B10=G1)*(C2:C10<>""))

or

=IFERROR(INDEX($A$2:$A$10,AGGREGATE(15,6,(ROW($A$2:$A$10)-ROW($A$2)+1)/(($B$2:$B$10=$G$1)*($C$2:$C$10<>"")),ROWS(G$2:G2))),"")

]]>Awesome that works, thanks!]]>

Try:

=[@Mean]-(SUM(SUMIFS([Mean],[35S],[@35S],[v.Con],"NSB",[D1],IF([@D1]="","",[@D1]))))

Awesome that works, thanks!

]]>Cross-post:

https://chandoo.org/forum/thre…o-create-a-formula.44187/]]>

Cross-post: