I am doing a vlookup across multiple sheets and know i will have some #No Match results, however i want to make sure those rows that do not match have a specific response in the cell which is a blank result. How can i accomplish this?
Current formula i am using:
=IF(ISERROR(VLOOKUP([BE GEO ID]1, {FY21 Radius Partner Coverage Ingram Micro Range 1}, 5, false)), VLOOKUP([BE GEO ID]1, {FY21 Radius Partner Coverage Tech Data US Range 1}, 12, false), VLOOKUP([BE GEO ID]1, {FY21 Radius Partners Synnex Comstor US VPM Range 1}, 12, false))
Additional question, is there a limit to how many sheets you can do a cross sheet vlookup on?
