Finding values from another cell range?

[jpettit]

Hi there...
I'm looking for a way to fill in a list of user's full name.
I have a list of userid's and a count. I want to be able to know what the users full name is and fill it in the adjecent cell (Cell C2). That value from (F:F) is found by matching to the userid in E:E.
Any ideas on how i can achieve this? Thanks.

APP Inventory.xls
	A	B	C	D	E	F
1	USERID	COUNT	NAME		USERID	NAME
2	user1	4			user1	UserNumber1
3	user2	2			user2	UserNumber2
4	user3	23			user3	UserNumber3
5	user4	42			user4	UserNumber4
6	user5	1			user5	UserNumber5
Sheet4

 

[Von Pookie]

I believe you're looking for a VLOOKUP function:

Book1
	A	B	C	D	E	F
1	USERID	COUNT	NAME		USERID	NAME
2	user1	4	UserNumber1		user1	UserNumber1
3	user2	2	UserNumber2		user2	UserNumber2
4	user3	23	UserNumber3		user3	UserNumber3
5	user4	42	UserNumber4		user4	UserNumber4
6	user5	1	UserNumber5		user5	UserNumber5
Sheet1

 

[rs2k]

Put this formula in C2 and copy it down.

=VLOOKUP(A2,$E$2:$F$6,2,0)

I have misinterpreted a few posts today, if this is not what your asking, (sorry) please post back.

Colin