Need to get value in fourth column i f i give input of values in first 3 columns?

AC->1>Org1    return ddd CV->1>Org1    return ddd   Lookup is not working? Any other solutions please? Am actually need to pick this values from external tool by connecting to this spreadsheet. Ev...