+ Reply to Thread
Results 1 to 15 of 15

Formulae or Lookup Tables?

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    01-09-2009
    Location
    NJ/NY
    MS-Off Ver
    Excel 2007 & 2016
    Posts
    124

    Re: Formulae or Lookup Tables?

    I've attached a sample spreadsheet. This sample only has Black, Caucasian and Hispanic races, and there is no differentiation between the pediatric and adolescent equations (but there are with other equation sets I'll be using). I've listed the equations I'll be using for this group; note that the parentheses may not be correct (I just pasted them in).

    I just realized there's a problem with my lookup table; the age for adult males begins at age 20 while the age for adult females begins at age 18 . Any suggestions for this?

    Thank you.
    Attached Files Attached Files

+ 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] Understand lookup, index & match formulae
    By Dushantha in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-18-2012, 05:50 AM
  2. Issue with LOOKUP and Advice on crrect formulae
    By pranabdeb in forum Excel General
    Replies: 8
    Last Post: 04-18-2012, 03:44 AM
  3. Excel 2007 : Lookup different tables
    By toclare84 in forum Excel General
    Replies: 6
    Last Post: 08-18-2010, 04:16 AM
  4. 4 criteria lookup formulae
    By Hitmanforprez in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-14-2007, 08:23 PM
  5. [SOLVED] Lookup tables
    By Dave in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-07-2005, 09:07 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