Microsoft Office Forums - View Single Post - Need help with vlookup

Thread: Need help with vlookup

View Single Post

Old

03-06-2017, 08:26 PM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows Vista

Windows Vista jeffreybrown uses Office 2007

jeffreybrown uses Office 2007

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown has a spectacular aura about

Default

Well let's say your Vlookup is =VLOOKUP(A1,$D$1:$E$8,2,0)

If you add a record to row 9, the VLOOKUP would fail because it is not a dynamic range.

So instead, reference the entire column =VLOOKUP(A1,$D:$E,2,0)

Reply With Quote