+ Reply to Thread
Results 1 to 2 of 2

Table Assistance

  1. #1
    Registered User
    Join Date
    01-16-2022
    Location
    Somewhere In Wales
    MS-Off Ver
    Office 365
    Posts
    1

    Table Assistance

    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

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: Table Assistance

    Try
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] VLOOKUP Table Assistance
    By Liverpool6 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-04-2019, 02:30 PM
  2. Pivot Table Assistance
    By Mike Johnston in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-21-2015, 01:32 PM
  3. Pivot table assistance
    By tdevine in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-13-2013, 08:34 AM
  4. Table Assistance
    By artikyulashun in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-21-2012, 06:13 PM
  5. Pivot Table Assistance
    By drewmann in forum Excel General
    Replies: 1
    Last Post: 03-28-2012, 09:50 AM
  6. Need Pivot Table assistance
    By razor0323 in forum Excel General
    Replies: 1
    Last Post: 06-22-2011, 06:42 PM
  7. Need Assistance With Pivot Table Please
    By Glenn E. White in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-27-2005, 08:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1