View Single Post
 
Old 02-03-2011, 02:51 PM
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,

If I understand correctly, put this formula in A2 and then fill down:

Code:
=VLOOKUP($B2,$C$2:$D$6,2,0)
Hope that helps...
Reply With Quote