•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Vlookup on empy field with referece to line above
Vlookup on empy field
I have this sheet where every article (with “default code”=article number) has 2 prices:
a “Zelfstandige “ & a “Partikulier” price (field pricelist_rule_ids/pricelist_id)
So article “B ASO 000000” has 2 prices: “999.999,00” & “1.000.000,00”
These prices have to be updated (via lookup)
Vlookup based on ”default_code” is possible for the first line, but nut so for the second line.
Is there an elegant way to solve this?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#financial modeling with spreadsheets
#Excel compatibility
#cloud-based spreadsheet applications
#no-code spreadsheet solutions
#Excel alternatives
#Vlookup
#Excel
#default code
#article number
#empy field
#lookup
#Zelfstandige price
#Partikulier price
#price update
#pricelist_rule_ids
#pricelist_id