multiple vlookup

Hi everyone, I am new to excel codng and require your help in solving the problem i am facing. My data set contains different project (10 in total) with each project containing multiple materials (M1,M2,M3,M4...) under it. In front of each material is its corresponding volume. Note that inside a...

I would like to calculate the IRR of multiple different projects, I try to take array of cashflow and dates of different projects, then using XIRR, but XIRR can only calculate continuous data. Below is a simplify sample, I can manually put all the data of one project together, but I can't do...

Hi Im trying to lookup two values that come from two comboboxes of a userform and the result to appear in a textbox The values of the comboboxes are related to two different name ranges on my sheet 2 and the table array for the lookup formula is in the same sheet (sheet2) I want that a button...

Hello, I am in some trouble when trying to use vlook up with multiple conditions. I have read a few threads but I can't seem to make it work for my task. Can you explain me on this example? We have two products in two different storage locations each. I want to see sales matched with the stock...

Hi I have been struggling with this one and have been trying to use and array. My data is arranged as per the below: Tab 1 table headers row 3, table data row 4 ID (Column D) Alpha (Column E) ID123 XYZ ID146 ABC ID123 XYZ This continues for around...

Hi All! I've been working on this all day! <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I am able to get the following two formulas to work independently, but not together… I know I’m missing something, but I cannot figure out what...

Need your help in the following matter. I have a master data excel workbook with 5000 records and 90 columns. There is also another Reporting workbook where I need to populate information about 250 resources. This sheet has 25 columns out of which 20 columns are to be populated with values...