Consulting

Results 1 to 11 of 11

Thread: Lookup value in table with two criteria in rows

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Contributor
    Joined
    Mar 2009
    Location
    Porto, Portugal
    Posts
    180
    Location

    Lookup value in table with two criteria in rows

    Hi
    I'm stucked with this issue today. Maybe it's the new years's eve hangover still.

    In the attached file I have 2 sheets.
    One has data with 5 columns for each month.
    What I intend to do in the other sheet is to lookup for values in the first sheet related to the month I choose.

    I have tried some combinations of lookup, match and index functions but I always get errors.

    I would appreciate your help

    Thank You very much
    Attached Files Attached Files

Posting Permissions

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