Lookup a value from non-sorted data
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
|