Problem with a look up and several other issues...

[dwhite612]

Here is my problem: I have an excel workbook with 2 worksheets called "settlement statement" and "balanced file new"
I wish i could show more of the settlement statement but I think this will give you the basic idea. What I would like to do is set up in the "balanced new file" a cell that looks for any cells in lines #801-811 that have exactly the same text in the G column and then adds the dollar amount exactly to the right of each in the O column and sums the total of each with the same name then in one cell on the "balanced new file" sheet.
So if I have 5 cells in column G that say "Commonwealth Lending" I want the cell in "balance new file" to look for each of those and add them. In "balance new file" the information will enter into two cells: one with the name and the one directly to the right of it with the summed amount.

FINALHUD.xls
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
94	801	LoanOriginationFee			to									$456,456.00
95	802	LoanDiscount			to
96	803	AppraisalFee			to									$5,464.00
97	804	CreditReport			to									$45,645.00
98	805				to
99	806				to									$54.00
100	807				to
101	808				to									$56.00
102	809				to									$45.00
103	810				to									$45.00
104	811											(POC)
Settlement Statement

If I did a horrible job of explaining please post and I will try to add more detail. And by the way...what is that &nbsp that shows in all of the cells.

Thanks, David

 

[jdee]

In answer to your question re: showing worksheet on page. In the FAQ's here is what is stated.

What is this "" thing, why is it showing up in my HTML Maker example and how can I get rid of it?
The "" is HTML code for a "non-breaking space." When used correctly, it appears as a normal space and you never even know it is there unless you look at the code. However, since the board was upgraded in February 2005, we have been unable to get the board to interpret this HTML tag correctly and it will display the tag in the post instead of a space.

Since the HTML Maker uses this special tag in the code it creates it will display the "" in the posted examples unless you copy the source code of the example. Click the "View Source" button provided on the page and it will display the source code of the example in a text box. Do not "View Source" on the page itself (yes, we can tell when you do this when we inevitably have to remove the code from your post). Copy all of the code displayed in the textbox and paste it into your message. The "" tag will not display in the posted example.