Might be a simple question - but I'm struggling so please help!
To set the context: 2 Sheets, data below: Sheet1
The goal is: To extract the data from sheet2 and implement it into sheet1 via a V-Lookup if formula. The data also won't be an exact match (ie Dog to Dogs) In English, it would translate to: if the name of the animal in sheet 1 matches any of the names of animals in sheet2 then extract the data in sheet2 on average lifespan and implement it into column C in sheet1.
Once I figure out this formula it'll apply to a more complex sheet.
Thanks in advanced.
Aucun commentaire:
Enregistrer un commentaire