Thread
: [Solved]
Need to search a column for a macth and return a result from a third column
View Single Post
02-03-2011, 02:51 PM
Colin Legg
Windows 7 32bit
Office 2010 32bit
Expert
Join Date: Jan 2011
Location: UK
Posts: 369
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...
Colin Legg
View Public Profile
Find all posts by Colin Legg