Forum Discussion
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...
=IFERROR(INDEX($A$1:$D$20,MATCH(1,INDEX((A24=$A$1:$A$20)*(B24=$B$1:$B$20)*(C24=$C$1:$C$20),0,1),0),4),"")
as in attached file