Results 1 to 3 of 3

Excel Formula help / Advice for a Dummy

Threaded View

  1. #1
    Registered User
    Join Date
    04-01-2023
    Location
    Canada
    MS-Off Ver
    Microsoft Office 365
    Posts
    30

    Excel Formula help / Advice for a Dummy

    Hi all,

    Looking for any wizards out there who can help me build some formulas to try to achieve the below described goals for my attached excel file.

    Any help, advice, or direction would be greatly appreciated!

    Goals:

    Return value in column H from "PRL1A PRL2A PART NUMBER DATA" sheet to cell L4 on "PANEL BUILDER" sheet.
    Return value in column I from "PRL1A PRL2A PART NUMBER DATA" sheet to cell M4 on "PANEL BUILDER" sheet.
    Return value in column J OR K from "PRL1A PRL2A PART NUMBER DATA" sheet to cell N4 on "PANEL BUILDER" sheet.

    Variables:

    Variables to determine returned values in column H & I ("PRL1A PRL2A PART NUMBER DATA" sheet) to be controlled by cell dropdowns A3 through G3 ("PANEL BUILDER" sheet). Equivalent Array data for these drop downs to reference are in the same order on the "PRL1A PRL2A PART NUMBER DATA" sheet columns A through G.

    The variables to determine returned values in column J OR K ("PRL1A PRL2A PART NUMBER DATA" sheet) is controlled by the dropdown variable in H3 ("PANEL BUILDER" sheet). EG. If H3 is "SURFACE" data to be returned from column J ("PRL1A PRL2A PART NUMBER DATA") If H3 is "FLUSH" data to be returned from column K ("PRL1A PRL2A PART NUMBER DATA").
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA code advice/Excel advice for summing groups of numbers
    By paulblower in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-17-2014, 05:47 AM
  2. excel dummy
    By akwoo in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 07-10-2013, 10:34 AM
  3. Excel Dummy Here
    By Innova in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 03-15-2013, 01:09 AM
  4. Excel dummy
    By Mavisto in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 01-24-2013, 06:48 AM
  5. Excel Formula Advice for CO2 Calculations
    By Steve Pim in forum Excel General
    Replies: 2
    Last Post: 12-17-2011, 06:37 PM
  6. Excel dummy needs help!!!
    By brianerdelyi in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-12-2006, 09:57 AM
  7. Excel Dummy - Please Help!
    By Ed in forum Excel General
    Replies: 9
    Last Post: 11-13-2005, 04:10 PM

Tags for this Thread

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