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!

Hi
Maybe you are looking for the VLOOKUP function ?

@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),"")

Please Login or Register  to view this content.

$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!