•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