Functions

vlookup array in excel VBA
HI I am using the following formula Sub find() Range("C150:H150").Value = Application.WorksheetFunction.Vlookup(Range("A21"),Range("A246:P345"), columns(5,6,7,8,9),False) This way I have lot of rows in which I need to use array or loop . end sub Error which I am getting Unable to get the Vlookup propert... 18 Feb 2005 11:08

Vlookups array function by Alan Beban
I had down loaded the array functions by Alan Beban. Have them installed as addins. When I run the function I get only one line. Also it will not allow wild cards to be used or to CONCATENATE cells for the lookup valve. ID Counts ac {=VLOOKUPs(D1,A2:B14,2)} ab 845 ac 424 ad 249 ac 231 af 121 ... 17 Feb 2005 17:13

Computing Sales Tax and Retail Price from a number
Hello All, The situation is this... When given a new product, the user is given the price to a customer which includes sales tax. This number is typically a simple number such as 50.00 or 20.00. The issue is that the *system* requires that retail price and sales tax are entered separately, such as Retail... 16 Feb 2005 15:58

formatting numbers
I'm using an internal system in my company where I get the results in excel using som sort of american excel standard. the numbers come out with a space (1000 separator) between numbers (one million is spelled 1 000 000). This is not the 1000 separator you can choose in FORMAT-CELL-NUMBER but some other stand... 16 Feb 2005 13:24

How do you calculate rate of return on monthly cash flows
Can I use the IRR formula for internal rate of return calculations for monthly cash flows? If so do I multiply the result by twelve? If not how do I calculate the annual IRR using monthly cash flows? Thanks for your help. ... 15 Feb 2005 23:42

PPMT formula that generates equal payments
Sorry I figured it out. Use a interest rate of zero! -----Original Message----- Does anyone know if its possible to get equal payments out of the PPMT formula. That is, its set up to generate an annuity repyament profile. I am wondering if I can set it up with inputs that will generate equal pr... 15 Feb 2005 14:41

calcuate bond yields
I need to calculate bond yields to different dates such a maturity, retraction dates etc. I work in excel 2003 ... 13 Feb 2005 23:57

SUMIF
i want to do a conditonal sumif only searching on the first 13 characters of the items in the list. ie. "Total Revenue" of what might be "Total Revenue - All SE Accounts" How can I use a variable instead of a fixed value to search on? Any ideas on how I might be able to do this? Thanks in advance. Joe ... 12 Feb 2005 17:09

SUMIF function
Hi everyone, first post for me, I have been using the sumif function the last couple days and I've was wondering if there is anyway to have more than 1 range and criteria for this function or is there another function where I can do this? Below might better illustrate what I'm trying to do: Column 1 ... 12 Feb 2005 17:09

simultaneous v&h lookup - approaches...
AFAIK, Excel has no function allowing simultaneous search for 1 value along leftmost column of a table range and then also search horizontally across table top row. 1 way to do this is to embed a LOOKUP to figure out how many columns or rows to index over (in case of VLOOKUP/HLOOKUP respectively). Anything els... 12 Feb 2005 17:09