Forum Discussion
Merging data to import pollution values
Just to clarify, you would like to see in GPS sheet only the rows where the Date field matches with that of Measures sheet. Is that correct?
Match/Countif/Vlookup formulae should be able to help. If you could upload a excel file with some realistic sample data, it will help the contributors here to give a specific solution.
Hi Kodipady, thank you
Yes on the GPS sheet i would like to see the pollution data from the measures sheet if the date and time match. so if the Date and Time on the GPs sheet is found on the Measures sheet - the data values in col B:I for the matching line is copied into the matching line on the GPS sheet Col D:K - this way i have a sheet with of data values and GPS details so that i can import this to say Bing Maps or similar
I have added a file so hopefully this has uploaded,
thank you , this was useful.
Please check the following formula, you can paste this to row 2(column D to K) of GPS tab.
=IFERROR(VLOOKUP([@date],Table1,COLUMN()-2,FALSE),"")
If there is no date match in Measures tab, it will give a blank cell. now you can filter on column D for non-blank rows. . i have attached a version with these changes.
hope it helps!!