Hi,

I'm a newbie in this forum and pls help me.

I have 2 columns; A and B. What I want to do is look for a value in column A, based on reference value in a cell. When the value is found, i will then use vlookup to point the value in column B.

Normally I would use lookup(lookup_value,array) to do this. If the data is sorted in an order (ascending or descending) it would be no problem BUT if data is non sorted (2 or 3 same data may appear at different row in the column), the formula will point me to the value at lower row of the column.

The data is actually acquired from a machine and will be used to present a scattered graph.



Is there any better way or specific formula to do this?

Regards,
Udea