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

Thread: Vlook up multiple sequence

View Single Post

Old

01-30-2017, 08:15 AM

Kev

Kev is offline

Kev uses Windows 7 64bit

Windows 7 64bit Kev uses Office 2016

Kev uses Office 2016

Office 2016

Novice

Join Date: Jan 2017

Posts: 7

Kev is on a distinguished road

Default

One way:

Code:

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

see attached workbook.
formula in column C of sheet "LookUp"

Attached Files

LookUp.xlsx (9.5 KB, 12 views)

Reply With Quote