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 help needed please VLOOKUP :)
C_Mababejive
Posts: 11,668
Forumite
deleted.................................................................................................................
Feudal Britain needs land reform. 70% of the land is "owned" by 1 % of the population and at least 50% is unregistered (inherited by landed gentry). Thats why your slave box costs so much..
0
Comments
-
Firstly there is an error in the formula.
'codelookup'!A2 D385 refers to a table on sheet codelookup that should exist between cells in the range A2:d385. Note the colon between the cells defining the outer corners of that range.
Is there data there?
If so then also note that the column being used for the lookup needs to be sorted in ascending order otherwise data can be missed.
One description of use of the formula at https://www.techonthenet.com/excel/formulas/vlookup.php0 -
Hi,,yes there is a colon but MSE just keeps inserting a grinning face. I have homed in on the problem in that the codelookup sheet isnt currently visible.. just playing with VBA to set properties to visible..Feudal Britain needs land reform. 70% of the land is "owned" by 1 % of the population and at least 50% is unregistered (inherited by landed gentry). Thats why your slave box costs so much..0
-
This problem is now fixed
Feudal Britain needs land reform. 70% of the land is "owned" by 1 % of the population and at least 50% is unregistered (inherited by landed gentry). Thats why your slave box costs so much..0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 355.9K Banking & Borrowing
- 254.9K 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