Forum Discussion
Issues with IFs And Formula
I have been Trying to get the correct formula for Hours and keep getting a False Error when I add the true and false out put in.
Getting a Spill Error for the hours to began
You need to get acquainted with all of the many ways that Excel can look things up in tables. Probably the most basic function is VLOOKUP, which I've used here. There are more sophisticated ways, XLOOKUP, INDEX and MATCH....among them.
If you make the table larger, you'll need to modify the size the the referenced range in the formula, but as with the earlier example, this gets you started.
A really good site is exceljet.com. I've started a query for lookups here: https://exceljet.net/search?query=lookup
You can also find lots of good resources on YouTube if you prefer video, with Leila Gharani one of the better
https://www.youtube.com/c/LeilaGharani
- Thank you so much for the help. is there any site or classes you would recommend to take to help me get acquainted much better.