Forum Discussion
Katie Short
Aug 31, 2018Copper Contributor
Problems with =VLOOKUP formula
I have a budget spreadsheet I am trying to improve. In one section, I have a dropdown menu of locations and I want the next column over to auto populate km once a selection has been made (and then th...
Lorenzo Kim
Sep 01, 2018Bronze Contributor
Ms. Short
attached is a revised sample.
it has 2 approaches..
First sheet = by VBA
2nd sheet = by Formula
hope this helps
thanks
- Katie ShortSep 03, 2018Copper Contributor
Thanks very much Lorenzo! I will give that a go. Appreciate the help!
- Lorenzo KimSep 03, 2018Bronze Contributor
Ms. Short
Welcome. hope it helps...