Forum Discussion
Excel formula help
Hi all,
I'm trying to create an excel formula and don't know how to start. I know what I want it to do, but don't know how to make it work. Please see the attached PDF. Thanks!
Dean
This is the difficult part!
Anyway, I've updated the workbook with another formula.
25 Replies
- me012819Copper Contributor
to signify any formula first type =
- Haytham AmairahSilver Contributor
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
- testing outCopper Contributor
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
- Haytham AmairahSilver Contributor
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??