Now Should your spreadsheet isn't constructed by doing this, then usually do not use VLOOKUP. Use The mixture of INDEX and MATCH functions in its place. Case in point one: Use two conditional formats with requirements that utilizes AND and OR exams The following case in point reveals the usage https://bildsite.de/datenrettung-und-datenwiederherstellung-sicherheit-im-digitalen-zeitalter/