Hello
Thanks for the hints.
So far no good results, basically I've cleaned the 3 columns and set all to
numbers, , opnened all in a new worksheet, no trailing spaces, etc.
I've exteneded $B$1:$C$150 which is the range where it should look for a
matching value.
I dont know what the ,2,0 does, maybe if you can explain me I can help a bit
to solve this.
Regards



"xlmate" wrote:

Check that you have numbers in the table and not text that look like numbers,
and that there are these value in your table as provided in your example.

Also check that there are no leading and trailing spaces in the cells that
contain values.

try inputting your example in a new workbook and apply the formula and see
if its works. Its does work for me.

HTH


--
Your feedback is very much appreciate, pls click on the Yes button below if
this posting is helpful.

Thank You

cheers, francis









"dab" wrote:

Hello xl
Thanks for your help
Unfortunately I get a #N/A result on D1
Regards


"xlmate" wrote:

Hi dab

Place this formula in D1

=VLOOKUP(A1,$B$1:$C$4,2,0)

Does this do what you want? Pls post back if it doesn't

HTH
--
Your feedback is very much appreciate, pls click on the Yes button below if
this posting is helpful.

Thank You

cheers, francis


"dab" wrote:

Good day,
Thanks for looking
I have the following dilema
Column A has 782 cells ramdomly filled with numbers between 1 and 150
Column B is an ascending list from 1 to 150
Column C has random values for each cell on column B

Will it be possible to show me how to scan column A and for each value
encountered, do a match on column B and upon matching it, post the
corresponding value on column C on say column D?

Example:
origin
----A-----B-----C
1-- 4---- 1 ----4.56
2-- 1---- 2 ----2.36
3-- 2---- 3 ----1.23
4-- 2---- 4 ----6.52

Result
----A-----B-----C-----D
1-- 4---- 1 ----4.56--6.52
2-- 1---- 2 ----2.36--4.56
3-- 2---- 3 ----1.23--2.36
4-- 2---- 4 ----6.52--2.36

Thanks for your help
Regards