Thread: Find Data In One Column & Report Corresponding Value In Another

I have done this in the past but for some reason cannot remember how I have a list of names that I need to find salaries for. What I need is a function that will look through a column or a named range and report the salaries for each person when it finds. I tried doing an IF function but it only seemed to look at that same specific spot in the range and not search the entire range. Any help would be greatly appreciated!

Thanks!

@arthurbr

Thanks for your response. I tried using that and wasn't having any luck but that doesn't mean it is the functions fault I think that I have it working using SUMIF but if I don't know how it will hold up if I need something other than a number. Thanks again!

I think I had a similar issue. I got help from someone and he used the VLOOKUP function.

For example, if your list of people you want salaries for is list 2, and the list of salaries for everyone is list 1 this formula will give you the resulting table below

=IFERROR(VLOOKUP(D3,$A$3:$B$9,2,0),"")

	A	B	C	D	E
1	list 1			list 2	
2	name	salary		name	salary
3	Dave	25000		Amy	81000
4	Jeff	150000		Karen	28000
5	Dan	54000		Joe	21000
6	Amy	81000			
7	Joe	21000			
8	Karen	28000			
9	Mike	190000			
10					
11

$A$3:$B$9 is the array. "D3" is the value you are going to search for in the array. "2" is the second column of the array, "0" tells the formula the results have to match exactly (e.g. Mike does not also include Mikel [if there was one]).

@captainentropy

Thanks for your help, I'll give it a shot!