Search a column, copy the field next to it.

[betojss]

Hello,

I've seen this answered before but it's not specific and doesn't work for my situation.

Imagine I have Client ID on column A and Client name on Colum B. Let's say from A1 and B1 to A10 and B10.

Now, on another part of the same SHEET and workbook (of course) let's say, H1, I have a number that is the result of another formula. Let's say "2", which was the sum of C1 and D1.
I need excel to search for that 2 on column A and display its respective "Client ID" on cell H2, how do I do that? I was reading at another post and got this:

http://www.mrexcel.com/forum/showthread.php?t=321875

index(q2:q30,match(max(r2:r30),r2:r30,0))

However, this doesn't apply because I'm not looking for the biggest number, instead I'm looking for a specific number which is on the sheet. Help please?
I'm sorry if this was confusing, this is my first post on this forum ever.
Using Excel 2010 Prof.

 

[Nalani]

Hi and welcome to the Board.

Is this what you are looking for?

Excel Workbook
	A	B	C	D	E	F	G	H	I
1	ID	Name	No.	No.
2	4	Tom	1	1				2	Sally
3	3	John	3	2				5	Bill
4	2	Sally
5	8	Frank
6	7	Mary
7	9	Joe
8	10	Chris
9	1	Bob
10	5	Bill
Sheet3

 

[betojss]

YES! Thank you so much! you have saved me a ton of time.