samedi 14 août 2021

V-lookup if statement excel

Might be a simple question - but I'm struggling so please help!

To set the context: 2 Sheets, data below: Sheet1

Sheet2

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