The spreadsheet has 5 columns, two of which I need to match the creiteria and bring back the data from a third cell. The spreadsheet itself contains over 60k line of data!
These are the headers on the spreadsheet. I need to match the computer name and the Item and bring back the data in value.
tComputerName tItem tAssetID tValue tType
The spreadsheet I need the returning cell info is on a separate spreadsheet and the matching criteria in on both axis. I have tried the formulas below but they don't seem to work?
help please!
{=INDEX(E2:E68826,MATCH(IF(A2:A68826=G10,IF(B2:B68826=M4,1)),0))}
=IF(ISNA(INDEX(A4:E68828,MATCH(1,(G10=A:A)*(M6=B:B),0))),"",INDEX(A4:E68828,MATCH(1,(G10=A:A)*(M6=B:B),0)))
Bookmarks