Help with Formula

[Joefried]

Hi
thanks for looking at my question

i need help with filling in the following Blank Spot

so far i have this:

=IF(A18="(blank)","",IF(A18="","",VLOOKUP(A:A,'Sheet 2'!C:J,8,FALSE)*C18))

however i would like if the answer is 0.00 continue to look until you find something that's at least 0.01 unless there is no

Best Regards
Joe

 

[prajul89]

what do you mean by that?

What I mean is Creating a new Formula in Visual Basic as you want.

 

[Joefried]

what do you mean by user defined function?

 

[Joefried]

and what would be the formula then?

 

[prajul89]

what do you mean by user defined function?

Like =SUM, =VLOOKUP or =SUMIF or any other formula that excel provide you can build your own Formula in Visual Basic as per your requirement.


Google "User Defined Fucntion in Excel" for more details

 

[Joefried]

let me ask you this,

am allowed to re-post this question since there might be a solution? and lets see if there is someone else that might know?

 

[prajul89]

Go on..........

and IF you got the answer then post here too. So that even I can improve my knowledge

 

[Joefried]

for sure

well since you're way better then me with this can you help me on how to post this question so it will be clear?

 

[prajul89]

for sure

well since you're way better then me with this can you help me on how to post this question so it will be clear?

So you want me to post the Question????
or just let you know what to post??

 

[Joefried]

please let me know what to post so i will get the reply and then i'll send a link to you for the listing i'll post it here (the link)

 

[prajul89]

please let me know what to post so i will get the reply and then i'll send a link to you for the listing i'll post it here (the link)

Well... Post something like this:


"How can I get the Vlookup Value of the next Item in my table, if the lookup Value of my Vlookup is 0. i.e, If the Ans of Vlookup is 0 then my formula should search for next lookup_value in my table_array. Is it possible.

Eg.
Table

<table border="0" cellpadding="0" cellspacing="0" width="128"><colgroup><col style="width:48pt" span="2" width="64"> </colgroup><tbody><tr style="height:15.0pt" height="20"> <td style="height:15.0pt;width:48pt" height="20" width="64">abc</td> <td style="width:48pt" align="right" width="64">0</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">rty</td> <td align="right">2</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">asd</td> <td align="right">0</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">qwe</td> <td align="right">12</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">abc</td> <td align="right">34</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">uio</td> <td align="right">21</td> </tr> </tbody></table>
so in the above table =VLOOKUP("abc",A:B,2,0) should be 34 and not 0."


Edit it as per you requirement.