Vlookup

		Microsoft Office Forums > Microsoft Excel > Excel
Vlookup

FAQ

Thread Tools

Display Modes

08-30-2012, 12:16 AM

Kevin@Radstock Kevin@Radstock is offline

Windows 7 32bit Vlookup

Office 2010 32bit

Office 365

Join Date: Feb 2012

Posts: 94

Kevin@Radstock is on a distinguished road

The thing with a VLOOKUP, it looks up to the right. So in your example the lookup table is E2:F200, If you swap the Columns around it should work. Otherwise use the INDEX & MATCH, to which I prefer.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Vlookup	ibrahimaa	Excel	5	03-04-2012 11:24 AM
Vlookup	ibrahimaa	Excel	8	01-03-2012 09:32 PM
Vlookup	Karen615	Excel	4	09-12-2011 02:30 PM
Can i do this with a VLookup?	foodstudent	Excel	1	01-21-2011 12:34 AM
Using IF & VLOOKUP together	junction	Excel	7	11-18-2010 05:15 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:36 PM.