khawarameer
Board Regular
- Joined
- Jun 2, 2009
- Messages
- 152
Hello All,
Take a look at these columns below;
<table style="border-collapse: collapse; width: 134pt;" width="178" border="0" cellpadding="0" cellspacing="0"><col style="width: 67pt;" span="2" width="89"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt; width: 67pt;" width="89" align="right" height="17">.00</td> <td class="xl65" style="width: 67pt;" width="89" align="right">810.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" align="right" height="17">.00</td> <td class="xl65" align="right">1,729.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" align="right" height="17">.00</td> <td class="xl65" align="right">1,594.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" align="right" height="17">.00</td> <td class="xl65" align="right">1,599.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" align="right" height="17">.00</td> <td class="xl65" align="right">498.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" align="right" height="17">498.00</td> <td class="xl65" align="right">.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" align="right" height="17">.00</td> <td class="xl65" align="right">1,852.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" align="right" height="17">.00</td> <td class="xl65" align="right">454.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" align="right" height="17">.00</td> <td class="xl65" align="right">50.00</td> </tr> </tbody></table>
I want to find the cell reference number of any value of column A (which is greater than 0) in column B. I could only manage to find values with my formula i.e.
=IF(A1>0,VLOOKUP(A1,$B$1:$B$9,1,0),0)
Your help is required.
Regards
Take a look at these columns below;
<table style="border-collapse: collapse; width: 134pt;" width="178" border="0" cellpadding="0" cellspacing="0"><col style="width: 67pt;" span="2" width="89"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt; width: 67pt;" width="89" align="right" height="17">.00</td> <td class="xl65" style="width: 67pt;" width="89" align="right">810.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" align="right" height="17">.00</td> <td class="xl65" align="right">1,729.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" align="right" height="17">.00</td> <td class="xl65" align="right">1,594.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" align="right" height="17">.00</td> <td class="xl65" align="right">1,599.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" align="right" height="17">.00</td> <td class="xl65" align="right">498.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" align="right" height="17">498.00</td> <td class="xl65" align="right">.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" align="right" height="17">.00</td> <td class="xl65" align="right">1,852.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" align="right" height="17">.00</td> <td class="xl65" align="right">454.00</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" align="right" height="17">.00</td> <td class="xl65" align="right">50.00</td> </tr> </tbody></table>
I want to find the cell reference number of any value of column A (which is greater than 0) in column B. I could only manage to find values with my formula i.e.
=IF(A1>0,VLOOKUP(A1,$B$1:$B$9,1,0),0)
Your help is required.
Regards