Thanks for the reply, unfortunately it didn't work.
I uploaded the original file.
What I'm trying to do is:
-In sheet REDE COLETORA DE ESGOTO match the pair of cells on column B and C with the corresponding pair in sheet APOIO.
-In sheet REDE COLETORA DE ESGOTO column D return the value from sheet APOIO column D that corresponds to the matched pair.
Can anyone give it a go on the original spreadsheet?
|