Extract cell value

[MrFinance1]

Hi,

When you have a list of names with corresponding %'s such as below and you have double names, such as Tom and Joe, how to get the first % that belongs to the respective name?

Tom 0.5%
Joe 0.25%
Brad 0.25%
Bill 0.35%
Charlie 0.26%
Tom 0.6%
Joe 0.30%

Many thanks

 

[kweaver]

A VLOOKUP will find the first one:

VOOKUP(A2,A2:B8,2,FALSE)

assuming your data is in A2:B8

 

[Snakehips]

@MrFinance1

Try like..

Excel 2010
	A	B	C	D	E
1	Name	Percent		Find	%
2	Tom	0.50%		Joe	0.25%
3	Joe	0.25%
4	Brad	0.25%
5	Bill	0.35%
6	Charlie	0.26%
7	Tom	0.60%
8	Joe	0.30%
9
10
Sheet7

Cell Formulas
Range	Formula
E2	=INDEX(B2:B20,MATCH(D2,A2:A20,0),)

Hope that helps.