Hi..
I am working on a file which has got 5 spreadsheets viz Sheet 1, Sheet 2, Sheet 3, Sheet 4, Sheet 5.. Every sheet has got a column called Tag which consists of a integer value. Sheet 4 consists of tag and owner. Now I want to populate the value in sheet 5 only if the tag in Sheet 4 matches with the tag in any of the sheets(sheet 1, sheet 2,sheet 3). If the tag is not available in any of the sheet. It should return Blank.
I applied And with Index match but it is giving me #Value Error.
Please help.
Thanks in advance for the help
Bookmarks