Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 02-11-2009, 02:48 AM
caholmes caholmes is offline vlookup question Windows Vista vlookup question Office 2007
Advanced Beginner
 
Join Date: Dec 2008
Location: Sydney, Australia
Posts: 54
caholmes is on a distinguished road
Default vlookup - getting it to work

Hi Tony G. When using a vlookup the value you are looking up must be in the first column of the list (see attached). I've created a simple version and then a more complete version for you to look at. The second formula will display "not in list" if the vlookup cannot find an exact match.
Attached Files
File Type: xls Office Forum Help - vlookup.xls (95.0 KB, 31 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Categories question & replying with attachment question glitzymama Outlook 0 03-15-2006 09:32 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:03 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft