Jumat, 25 Desember 2015

[ExcelVBA] Excel formula

 

Hi,

I thought somebody would have easier way to lookup the formula for a problem like this.
There are 3 variables(one each for <250, <500 for column lookup and <500,>=1000, >=500 and <1000 row lookup). if the column look up is less than 250 and less than 500 and row lookup is <500, the formula should pick up "1".  Pleases let me know if you need want me to further elaborate. Thanks a lot for your help!

lookup(<250/<500)
<500 1
> = 1000 1.5
>=500 and < 1000 2

__._,_.___

Posted by: Prasanna Kumar <pkj7461@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

.

__,_._,___

Tidak ada komentar:

Poskan Komentar