Microsoft Office Forums - View Single Post - Vlook up multiple sequence

Thread: Vlook up multiple sequence

View Single Post

Old

01-30-2017, 10:39 AM

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

If that works for the OP, it can be shortened to...

=VLOOKUP(A2,SupplierTable!$A$2:$C$6,IF(B2="a",2,3) ,0)

Reply With Quote