Hi all,

Please help me out with this !

Table A A B C D=(A/B)/(C/100) 12 12 45 1 4564 48 2 47 78 3 87 87 4 587 98 5 587 5 6 98 556

Table B D E 0.1 1 4 2 5 3 6 4 8 5 7 6 9 7

Here we have table A and table B In table A column D is a computed field from A, B , and C We have a similar column D in table B ( which is approximately equal to column D in table A) Now column D lets take first cell from table A , it needs to be compared with the entire column (not individual cell in table B , entire column has to be looked up) and if it matches wth any of the cell in column D in table B corresponding cell value of column e has to be picked up.........

Note that there is no common key field in both these tables. Also the number of records are not the same.