Formula to find text in a chart based on the contents of another cell

[msdvers4]

I have tried several formulas and I think what is needed it above me knowledge level. I am looking for a formula that identifies an ID # in one column, locates the same ID in a chart and returns with the user name that is associated with that ID #

The data in A:A, B:B, and C:C would change constantly, Data in G:G and H:H would only change when additional IDs and Users are added to the list.

Any help or direction would be much appreciated!

I will be posting a picture of the sheet I am working on.

 

[msdvers4]

Here is the picture of the sheet

 

[jtakw]

Hi,

Try this, LOOKUP or VLOOKUP:

Book3.xlsx
	C	D	E	F	G	H
2
3
4	A003	Kara	Kara		A003	Kara
5					A004	Carl
6	A008	Jamie	Jamie
7					A006	Mike
8	A006	Mike	Mike
9					A008	Jamie
Sheet856

Cell Formulas
Range	Formula
D2:D9	D2	=IF(C2="","",LOOKUP(2,1/SEARCH(C2,G$2:G$23),H$2:H$23))
E2:E9	E2	=IFERROR(VLOOKUP(C2,G$2:H$23,2,0),"")