Hi, I have a workbook that contains several sheets. One is the "Master list" ("Membership List") from which I need to extract data to put in others. I've managed to work some vlookup functions that extract data for some sheets which work OK, but I'm struggling to write a formula to extract vlookup data based on the contents of a particular Yes / No column in the "Membership List".
I've done a simple workbook attached (the original has far more columns, but they aren't relevant to this post) - what I need to do is to populate the contents of the "Dining List" with the names of those that are actually dining, ie, where the "Dining?" column has a "Yes".
I'm OK with the vlookup bit, but can't seem to get the correct syntax for the "If G (2 - 11) "Yes", then populate the cells in the Dining list; If "No", ignore the row.
I would also like to bring in the "IFERROR" statement as well but that's far too much for my abilities.
Not sure what the result will look like in terms of rows in the Dining List, but I need the rows to be without blank rows, ie in this instance there will only be 6 rows in the sheet.
I hope someone can help - it's probably a simple formula to an expert....
Thanks in advance.
Rgds
Mike Waring
Sorry, just noticed the stated versions of windows and Excel are out of date - I'm using W10, with Office 2021 Pro Plus
Bookmarks