I have a column of species names, common names and latin names. I would like the vlookup to look in both to find name and return latin my formula is as follows =vlookup(c2,species!a2:c813,3,false) this works as long as just looking at species name. I change it to =vlookup(c2,species!a2:c183,3,false) and it will look at common names I need both at once time