Ready, steady… save!
You don’t need a chart to join in. Here are 2 ways to record your savings:
1. Cross it off
Pop a chart into your first post. Saved an amount? Cross it out! Read more »
£0.01 £0.02 £0.03
2. Write it down
Skip the chart and add updates to your first post. Read more »
“Another +£3 saved today. Go me!”
Use +£ before each new saving so it counts towards your total.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
Excel puzzler
Comments
-
by heck but that's complicated! I may well take you up on that offer.0
-
Lookup only works if the lists are in ascending order, IIRC.
GGThere are 10 types of people in this world. Those who understand binary and those that don't.0 -
Thank you for all the information! I can't believe it was so stupid. Basically, I had written the children's name first name first, then last name. I had sorted by last name to sort things out. Basically, had I sorted by the first name, all this could have been solved. Case closed - many thanks for all your help everyone!0
-
As Chippy said, as you are wanting an exact match, you really should have a fourth argument in your formula of 0 or false. If you have this the list doesn't need to be sorted at all.
At present if you look up a name that isn't in the list, it will return the results for the nearest name alphabetically rather that alert you to no match.0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 355.9K Banking & Borrowing
- 255K Reduce Debt & Boost Income
- 456.2K Spending & Discounts
- 248.4K Work, Benefits & Business
- 606.1K Mortgages, Homes & Bills
- 179K Life & Family
- 263.9K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.2K Discuss & Feedback
- 37.7K Read-Only Boards