Forum Discussion
Excel formula help
This is the difficult part!
Anyway, I've updated the workbook with another formula.
That helped, but it didn't give me the necessary directions on what I wanted to do. It just showed me an example and the example didn't match what I was trying to accomplish.
So I'm going to try again. If you have to direct me to a video showing me how to do it, vs explaining it to me or showing me out right how the formula will need to work, please don't respond. Thank you.
De
Hi,
On the PDF you attached, let me understand that you're trying to do!
You typed the last name in the cell next to Round 1 in the second sheet, and if this name is matched with the last name in the first sheet, then you want to return the Head Coach in the corresponding cell in the first sheet??
Yes, that is correct. Anytime I put a name in the round, it should automatically associate the coach name and then put the head coach name in the other page. Can you do that? Thanks!
Dean
Well, but the data in the second sheet is not organized in a way that is easy to depend on in the VLOOKUP function.
To make the solution easier, you need to create a single table for all data in orders to be able to use the VLOOKUP or other lookup functions.
Otherwise, the solution will be difficult!
Can you combine them in a table (tabular form) as the data in the first sheet?- Thank you so much for your response and thanks for taking the time to look at this. If I need to break things out further, how would it be organized? I need to page two to remain the way it is. If you want to change page one, let me know how it would be organized? Page two is where each coach will know what player they get and the number next to the player is already a vlookup. Thanks!!
Dean