Results 1 to 4 of 4
  1. #1
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Database (Function) Help (Excel xp)

    I'm sure there is a simple solution to this and that it's been covered before...I really miss the SEARCH capability in the Lounge. Hope it returns soon!

    In the range B3:B33, I have a chronological list of dates (one date for each day in the month). In the C column, I have the daily sales figures (dollars) that correspond with each date (from the B column). At the bottom of the list (C35), I have used the MAX function to find the best daily sales amount for the month. In B35, I need a formula that will return the date that corresponds with the best sales amount shown in B35. It's a shame that VLOOKUP doesn't work right to left.
    - Ricky

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Database (Function) Help (Excel xp)

    If you're looking for a "VLOOKUP to the left", there is Steve's Star Post <!post=Vlookup to the left? (Excel:97-2002),244408>Vlookup to the left? (Excel:97-2002)<!/post> - found it using the Star Post Index at the top of the forum.

  3. #3
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Database (Function) Help (Excel xp)

    I knew that I had seen this subject covered at least once before! But I didn't remember it being a Star <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    Thanks
    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    - Ricky

  4. #4
    2 Star Lounger
    Join Date
    Sep 2003
    Location
    Louisville, Kentucky, USA
    Posts
    134
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Database (Function) Help (Excel xp)

    I usually use the INDEXMATCH method instead of VLOOKUP and HLOOKUP. I don't like the LOOKUP functions because you have to put in a fixed numeric offset so if you insert columns into your table, you screw up the results of your VLOOKUP function. Similarly, adding rows would mess up HLOOKUP results. The INDEXMATCH method automatically adjusts and picks up the correct result.

Posting Permissions

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