vendredi 20 novembre 2015

Using VLOOKUP with an IF statement to search a range and return description

I have a sheet (sheet 1) with the name of an event and another sheet (sheet2) with the name of the same events along with event descriptions. Not all events from sheet 2 are in sheet 1.

I am attempting to obtain a description of the event for sheet 1 if it is in sheet 2. Essentially, I want my formula to say is: if 'sheet1 a2' is in 'sheet2 a2:a200' return corresponding description from 'sheet 2 column b'.

Aucun commentaire:

Enregistrer un commentaire