Forum Discussion
Syncing Out Of Order Datasets
Hello everyone, In one spreadsheet, I have a list of origin cities in column A and a list of destination cities in column B. In column C, I have the mileage between the two. In another spre...
jucotransfer for such sample
Sheet1:
Sheet2:
rate into first sheet could be returned by
=IFNA(INDEX(Sheet2!C:C, MATCH(1,INDEX( (A2=Sheet2!A:A)*(B2=Sheet2!B:B),0),0)),0)