Vlook up multiple sequence

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

01-30-2017, 10:39 AM

jeffreybrown jeffreybrown is offline

Windows Vista Vlook up multiple sequence

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

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

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 09:38 PM.