Thread: Using VLOOKUP to autopopulate Unit Cost without changing old entries
View Single Post
 
Old 06-06-2017, 04:57 PM
Coronos Coronos is offline Windows 10 Office 2010 64bit
Novice
  
Join Date: Oct 2016
Posts: 4
Coronos is on a distinguished road
Default
I could be wrong, but I don't think you can do this without VBA.

There's probably a better way, but this is what I ended up with for entering line items in my invoicing workbook:

Range("K" & (ActiveCell.Row)).Select
ActiveCell = "=VLOOKUP(D" & ActiveCell.Row & ",'Service Items'!A: D,4,False)"
ActiveCell.Value = ActiveCell.Value

Column K is the item price on my line items sheet. 'Service Items'!A: D is my lookup range, where D holds the unit price. After looking it up, "ActiveCell.Value = ActiveCell.Value" takes the resulting value of the lookup and pastes it in place of the lookup formula.
Last edited by Coronos; 06-06-2017 at 05:00 PM. Reason: A: D (without the space) was interpreted as a big grin
Reply With Quote