Forum Discussion
Excel formula help
This is the difficult part!
Anyway, I've updated the workbook with another formula.
Hi,
I will point you in the right direction!
You just need to one of the lookup functions such as VLOOKUP.
So, please check out this https://support.office.com/en-us/article/VLOOKUP-function-0BBC8083-26FE-4963-8AB8-93A18AD188A1!
Regards,
Haytham
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?