Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Help for formula
Register FAQ

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 05-01-2009, 10:39 AM
Bird_FAT's Avatar
Bird_FAT Bird_FAT is offline Help for formula Help for formula Office 2007
Expert
  
Join Date: Apr 2009
Location: South East
Posts: 271
Bird_FAT is on a distinguished road
Red face Ooops
Sorry - didn't think to add in the Range Lookup

Quote:
=VLOOKUP(D4,A3:B43,2,FALSE)
Adding FALSE to the end tells the VLOOKUP function to only except EXACT Matches

Sorry about that!
Reply With Quote
 

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help for formula Need help with a formula tinkertron Excel 11 04-16-2009 11:43 PM
Help for formula Excel Formula Help Shahzad Excel 1 12-07-2008 04:13 AM
formula in excell curlymal Excel 2 02-09-2007 11:34 AM
Mailmerge Formula mridley Mail Merge 0 07-27-2006 03:16 AM
Help for formula Stuck on this formula!!!! CADmanJP Excel 2 03-10-2006 02:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:09 PM.

Contact Us - Privacy Statement - Top

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