double lookup

Hi. I have a VLOOKUP-problem I hope you guys can help me with: The input: 1) I have several worksheets in a workbook. Each worksheet is representing a project with financial figures. There is about 100 projects, so there are about 100 worksheets in the workbook. The names of the worksheets are...

Dear All, I have two tables, in table 1 i have a statement of more than one customers combined in sequential order, in table 2 i have customer numbers vertically placed and dates horizontally placed. i want to use a lookup function which may extract day end balance in front of each account...

Hello, I am attempting to create a sales quote creator. I have a product database in one sheet with product number, product, product options, and price in each column. I then have the 'sales quote creator' in another sheet with a dependent dropdown list (with product options being dependent on...

Hello everyone This is probably not a new issue, but was not able to find anything on it FYI - I am using Excel 2007 It will be much easier to understand if you look at the example table below (I am not able to post an image, sorry...) I am given the table with assigned values, plus couples of...

I'm trying several options but no one works. Let's see if anyone can help me. I have a sheet with country information, like: <table width="923" border="0" cellpadding="0" cellspacing="0"><col style="width: 48pt;" width="64"> <col style="width: 76pt;" width="101"> <col style="width: 48pt;"...

Thanks to this forum through which I got help & now in my workbook, in Sheet1, in cell address F9, I am able to fill a value present on Sheet2’s cell address M17 using ‘indirect’ function instead of a simple Excel function like F9’=Sheet2!M17’. In Sheet3, cell H6 I want to do FURTHER REFERENCING...

hi all, i have this complicated double lookup that i have to create a formula on. this will determine the price based on item no and customer. suppose the table looks like this: <TABLE style="WIDTH: 288pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=384...

Hello all, I am trying to get a cell in my spreadsheet to look up a value based on two values. I have a dropdown list that lists the worksheets in the workbook, and each worksheet has a table with width measurements for the columns and height measurements for the rows. I have a function that is...