+ Reply to Thread
Results 1 to 5 of 5

Link & read the relevant field from another sheet

  1. #1
    Registered User
    Join Date
    09-05-2011
    Location
    Shah Alam, Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    9

    Link & read the relevant field from another sheet

    Hi guys,

    I having difficulty to read the appropriate bands from another sheet for a value defined. Ie; if my value for 1L (column H) is 11.21 (in sheet, 'spotless') then my band value should be 20 (as per sheet, 'band'). Similarly, if my value for 18L is 391.17 then my band value should be 720.

    The file is attached herewith.

    Would appreciate your assistance.

    Thanks

    Vegobu
    Attached Files Attached Files

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Link & read the relevant field from another sheet

    As I can see, for the same pack sized there are different Band (Peso) also. How do we determine which one to pick up? Any logic behind that?
    Cheers!
    Deep Dave

  3. #3
    Registered User
    Join Date
    09-05-2011
    Location
    Shah Alam, Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Link & read the relevant field from another sheet

    Quote Originally Posted by msexcelathome View Post
    As I can see, for the same pack sized there are different Band (Peso) also. How do we determine which one to pick up? Any logic behind that?
    Oh yes, for each pack size there have 12 bands meaning if any value (in column EV) falls in the relevant range (ie; 1L, EV=61.5 then the band should be 80).
    Hope the above is clear.

  4. #4
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Link & read the relevant field from another sheet

    Nope.. Not yet clear.. I need a base data where I can link the Formula to.. Which I can not find anywhere on your sheet..

  5. #5
    Registered User
    Join Date
    09-05-2011
    Location
    Shah Alam, Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Link & read the relevant field from another sheet

    Hi

    My base data will be column EV (in sheet, spotless) which will be computed from my input of datas. Then i need to link the EV to the band value in accordance to the pack size (column H)

+ 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] Read today's date and pull relevant data
    By benjuk in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 06-24-2013, 05:14 PM
  2. Just cant get this I need MAster Sheet to produce the field that does not read off
    By detailingking in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-10-2013, 11:34 PM
  3. Replies: 12
    Last Post: 11-10-2012, 09:54 PM
  4. Replies: 0
    Last Post: 05-17-2008, 10:19 AM
  5. Replies: 4
    Last Post: 05-09-2007, 07:30 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