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...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.