Good Evening,
I'm having an issue with the formula required for the attached.
Essential the data in columns A and B are example data and essentially when I chose a number selected through data validation in column E, I wish for the data in column B which relates to it's number in Column A to be displayed under membership.
I've tried the if and VLOOKUP functions but cannot figure this out.
This is probably relatively easier but my brain's fried from trying hence the request for assistance.
Table Example.png
Bookmarks