Thread: Help for formula
View Single Post
 
Old 05-01-2009, 10:39 AM
Bird_FAT's Avatar
Bird_FAT Bird_FAT is offline 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