Search results

Thank you for your responses. I apologize for the inconveniences. I did not think the question was that complicated. I will look elsewhere.

Is it possible for the first term of a VLOOKUP formula to be a variable based on the contents of a cell?

Not to sound condescending, but if I were able to create a sample file with dummy data and having the desired output, I would not be seeking help here. Are these Forum rules for posting my situation? As simple as I am able to make it, I would like to: a) I have some Tenet Worksheets (TW) that...

I do a number of invoices each month that are based in part of billings from utility companies. The billings show the electrical meter or gas meter usage for various buildings. I use these readings to determine how much each tenet must pay for their share. To do this I have worksheets for each...

Hi dan_I, Thanks for responding. Yes, as you suspected, it is quite complex. I had also considered using Access, but know less about it than I do about Excel. I think I have been cleaning the individual worksheets (tenants, square footage, electric, gas, garbage, sewer, water, common area...

Hello All, I am very new to this site and pretty much a basic user of Excel. I have a situation where I have several buildings with several tenants with varying costs and expenses that are invoiced for each month. I (somehow) manage all of this info in a bunch of Excel worksheets that have...