data problems, matching large data sets with smaller known points

Hello,

I have a problem which I think is an easy solution but I just can't seem to figure it out.

column A: has very large data set like (1,1,1,1,2,2,3,4,5,5,6,6,7,etc..)
column B: has smaller data set like (1,2,3,4,5,6,7,8,etc.)
column C: has number associated with column B values (2,2.5,4,7,0.8,etc.)
Column D: i would like to match the values from column C to the number in column A (2,2,2,2,2.5,2.5,4,7,0.8,0.8,etc.)

if you understand what I'm asking ad could figure out the formula that would be great! I have been searching for an answer for this for awhile now.


thanks,
AG

Try this in D1:

=IFERROR(VLOOKUP(A1,B:C,2,0),"")

then copy down.

Hope this helps.

Pete

hello Pete,

It is getting closer, it is putting numbers in column D but they are not the right ones for some reason...for example the first row is as follows

1,3.6,1,69 where 69 should be 3.6

I am not sure how to use your function but if you could play around with it and ill do the same to hopefully fix it.

hope to hear from you soon!

ty
Andrew

Hello again pete,

I have it closer, it is working for the first part ie. (1) but when the next number comes up in column one (1,1,1,1,2<- now) it take the value from column B adjacent to it and not from the top. is there away for correct this?

thanks,

Copy YOUR formula to a post here.

Pete