Lookup table? Excel

[Closed]
Report
Posts
1
Registration date
Friday July 9, 2010
Status
Member
Last seen
July 9, 2010
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,
I am working from 3 different spreadsheets with meter reading information:
1-meter reading from date 6/8/2010 (Address|meter no|date|read)
2-meter reading from date 6/30/2010 (Address|meter no|date|read)
3-list of meters for test sample (address|meter no)

I would like to:
take spreadsheets 1 and 2 and match those to addresses on spreadsheet 3, while taking all row data and placing it on another sheet or tab; then subtract sheet 1 read data from sheet 2 read data to get a difference that is also placed on that new sheet or tab.

Example of final product:
Address meter no difference
123 apple st 123456 3000

Not sure if this makes sense...my excel skills are not too great.
Any help would be greatly appreciated!

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too