Need to search a column for a macth and return a result from a third column

		Microsoft Office Forums > Microsoft Excel > Excel
Need to search a column for a macth and return a result from a third column

02-03-2011, 02:51 PM

Colin Legg Colin Legg is offline

Windows 7 32bit Need to search a column for a macth and return a result from a third column

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...

Other Forums: Access Forums

All times are GMT -7. The time now is 02:28 AM.