Hi all i'm not very good with formulas in Spreadsheets so could do with some help please, I'm using Numbers 3.0
I have 2 tables, Each has information that i need but the information needs to be merged into 1 table.
My first table which i'd like to be the table used for all data currently has a 3 columns of interest, POSTCODE, IPS, LOCATION and there are 2 Columns with no data which needs populated, LATITUDE and LONGITUDE.
My second table has 3 Columns, POSTCODE, LATITUDE, LONGITUDE and these have all the correct data for them.
Table 1 & Table 2 do not have the exact same Postcodes but 95% of them should be, I would like to be able to create formulas that check for matching postcodes and if they match add the latitude and longitude to the proper cells.
If anyone knows how i can go about this it would be GREATLY appreciated!!!
Many Thanks
I have 2 tables, Each has information that i need but the information needs to be merged into 1 table.
My first table which i'd like to be the table used for all data currently has a 3 columns of interest, POSTCODE, IPS, LOCATION and there are 2 Columns with no data which needs populated, LATITUDE and LONGITUDE.
My second table has 3 Columns, POSTCODE, LATITUDE, LONGITUDE and these have all the correct data for them.
Table 1 & Table 2 do not have the exact same Postcodes but 95% of them should be, I would like to be able to create formulas that check for matching postcodes and if they match add the latitude and longitude to the proper cells.
If anyone knows how i can go about this it would be GREATLY appreciated!!!
Many Thanks