Vlook up multiple sequence

		Microsoft Office Forums > Microsoft Excel > Excel
Vlook up multiple sequence

01-30-2017, 08:15 AM

Kev

Windows 7 64bit Vlook up multiple sequence

Office 2016

Novice

Join Date: Jan 2017

Posts: 7

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)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sequence problem	Pecoflyer	Excel	2	01-10-2017 09:34 AM
Problem with correcting an index sequence	John Witmer	Word	5	05-13-2015 03:52 AM
VLook up search	Tralee6	Excel	4	08-07-2014 05:20 AM
Automatic numbering in captions out of sequence	Savager	Word	3	05-25-2012 07:22 AM
Excel sheet Sequence Number	belloffice	Excel	1	02-25-2010 02:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:20 AM.