Results 1 to 9 of 9

Vlookup/Hlookup

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-08-2009
    Location
    Bristol, UK
    MS-Off Ver
    Excel 2003
    Posts
    228

    Vlookup/Hlookup

    Hello All,

    I am stuck on a formula for the spreadsheet attached.

    On 'sheet 2' I have a drop down menu which selects an item and then calculates figures for that year. Unfortunately I currently have it set to lookup the figures for the 'Thing1'. I need the formula to look at each 'thing' and do the calculations for that. Hopefully the spreadsheet will make sense.

    I'm not sure if I need a Vlookup or what.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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