Excel Help, Using Lookup functions..

[IamDavid]

I can't seem to get this to work. I have 3 colums of data.

Data series 1----Data series 2----Data series 3 -------Return Value
5---------------- 1------------------5----------------------
3 --------------- 1 ------------------3---------------------
2 ----------------1-------------------2--------------------
7 ----------------1-------------------6--------------------
4-----------------1-------------------4--------------------
12----------------2------------------12--------------------
55----------------2------------------55--------------------

I need it to look at series 3, find the same numer in series 1 and return the value from series 2. This is just a simple example, I'm working with thousonds of values per series. Is what I'm looking for possable? Should I not be using VLookup at all?

 

[jersiq]

It's what you should use.

Assuming Column A is Series 1 in D1, you would put:

=vlookup(C1,A:B,2,FALSE)

And then drag it down all the rows of your data with the fill handle. In my second argument I put A:B, but you may need to tailor that to your actual data size. Are you having a problem with your vlookup function?

 

[NeoV]

jersiq is correct, vlookups take care of this

 

[IamDavid]

Thanks guys. Worked great.