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. Everytime i get 3 variables as input i.e the first 3 columns values, i need to fetch the corresponding value from col4
| AC | 1 | Org1 | ddd |
| AC | 4 | Org2 | ccc |
| AC | 3 | Org3 | bbb |
| AC | 5 | Org4 | aaa |
| AC | 7 | Org5 | ffff |
| CV | 1 | Org1 | ddd |
| CV | 4 | Org2 | ccc |
| CV | 3 | Org3 | bbb |
| CV | 5 | Org4 | aaa |
| CV | 7 | Org5 | ffff |
| BV | 1 | Org1 | ddd |
| BV | 4 | Org2 | ccc |
| BV | 3 | Org3 | bbb |
| BV | 5 | Org4 | aaa |
| BV | 7 | Org5 | ffff |
| RV | 1 | Org1 | ddd |
| RV | 4 | Org2 | ccc |
| RV | 3 | Org3 | bbb |
| RV | 5 | Org4 | aaa |
| RV | 7 | Org5 | ffff |
2 Replies
=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
Maybe try using a combination of concatenate and vlookup (see attached example):
