match item

[Sumeth]

banana tomato papaya
3 2 1 match "3" = banana
3 5 4 match "4" = papaya
2 4 2 match "4" = tomato

what is the formula ? in each row

 

[Duane Hookom]

I'm not sure what the formula is but the solution is to normalize your table
into:
ID Fruit TheNumber
1 Banana 3
1 Tomato 2
1 Papaya 1
2 Banana 3
2 Tomato 5
....
3 Papaya 2

You can then use simple SQL statements like
SELECT Fruit
FROM tblGoodFruits
WHERE ID = 1 And TheNumber=3;