Thread: Vlookup
View Single Post
 
Old 09-12-2011, 10:56 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Hi Karen,

You also need to specify a fourth argument, which tells it to do an exact look up:

=VLOOKUP(A2,'Sheet1'!$A$2:$B$141,2,0)

If you omit the fourth argument (it is optional) then VLOOKUP does an approximate match. This can be great when your data is sorted, because the formula calculates more quickly.
Reply With Quote