Microsoft Office Forums - View Single Post - [Solved] Help w/ Drop Down Lists

Thread: [Solved] Help w/ Drop Down Lists

View Single Post

Old

01-10-2017, 04:08 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

Not sure this is a better way, but you could try in B11 copied over and down...

=VLOOKUP($A11,$A$3:$C$5,COLUMNS($A$1:B$2),0)

Reply With Quote