Spreadsheet: 755221d1636726179-xlookup-several-columns-with-multiple-lookup-values-search-multiple-columns
Sheet: Outputs

ISSN 1 | ISSN 2 | ISSN 3 | ISSN 4 | Ranking
1073-449X | 1535-4970 | 0003-0805 |  | Need value from Column A in 'Ranking' tab here |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 |  | 4 | 15 | A | 1 | 14 |  |  |  |  |  |  |  |  | =[NAME])),""))& IF(B2="","",IFERROR(INDEX(Rankings!$A$2:$A$527,MATCH(1,MMULT(--(Rankings!$B$2:$C$527=$B2),{1;1}),0)),""))& IF(C2="","",IFERROR(INDEX(Rankings!$A$2:$A$527,MATCH(1,MMULT(--(Rankings!$B$2:$C$527=$C2),{1;1}),0)),""))& IF(D2="","",IFERROR(INDEX(Rankings!$A$2:$A$527,MATCH(1,MMULT(--(Rankings!$B$2:$C$527=$D2),{1;1}),0)),""))
1083-3668 | 1560-2281 |  |  | Need value from Column A in 'Ranking' tab here |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | U | 2 | 13 | F | 3 | 9
2045-2322 |  |  |  | Need value from Column A in 'Ranking' tab here |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C | 4 | 15
1424-8220 | 1424-8239 | 2379-3694 |  | Need value from Column A in 'Ranking' tab here |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y | 5 | 10
0925-2312 | 1872-8286 |  |  | Need value from Column A in 'Ranking' tab here |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | U | 2 | 13
0020-0255 | 1872-6291 |  |  | Need value from Column A in 'Ranking' tab here |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I | 7 | 8 |  |  |  |  | 0020-0255 | 1872-6291
2051-817X |  |  |  | Need value from Column A in 'Ranking' tab here
 |  |  |  | Need value from Column A in 'Ranking' tab here
 |  |  |  | Need value from Column A in 'Ranking' tab here
 |  |  |  | Need value from Column A in 'Ranking' tab here
 |  |  |  | Need value from Column A in 'Ranking' tab here
0031-9155 | 1361-6560 |  |  | Need value from Column A in 'Ranking' tab here
0043-1737 | 1365-3180 |  |  | Need value from Column A in 'Ranking' tab here
1424-8220 | 1424-8239 | 2379-3694 |  | Need value from Column A in 'Ranking' tab here
 |  |  |  | Need value from Column A in 'Ranking' tab here
1556-6013 | 1556-6021 |  |  | Need value from Column A in 'Ranking' tab here |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1556-6013 | 1556-6021
1932-6203 |  |  |  | Need value from Column A in 'Ranking' tab here
0162-8828 | 1939-3539 |  |  | Need value from Column A in 'Ranking' tab here |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0162-8828 | 0
1939-3792 | 1939-3806 |  |  | Need value from Column A in 'Ranking' tab here
1324-4272 |  |  |  | Need value from Column A in 'Ranking' tab here
1449-3098 | 1449-5554 |  |  | Need value from Column A in 'Ranking' tab here
2075-2180 |  |  |  | Need value from Column A in 'Ranking' tab here
1664-302X |  |  |  | Need value from Column A in 'Ranking' tab here
0218-1266 | 1793-6454 |  |  | Need value from Column A in 'Ranking' tab here
1757-4749 |  |  |  | Need value from Column A in 'Ranking' tab here
0169-2607 | 1872-7565 |  |  | Need value from Column A in 'Ranking' tab here
 |  |  |  | Need value from Column A in 'Ranking' tab here
 |  |  |  | Need value from Column A in 'Ranking' tab here
0925-2312 | 1872-8286 |  |  | Need value from Column A in 'Ranking' tab here
1520-9210 | 1941-0077 |  |  | Need value from Column A in 'Ranking' tab here |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1520-9210 | 1941-0077
0028-0836 | 0090-0028 | 0300-8746 | 1476-4687 | Need value from Column A in 'Ranking' tab here