Results 1 to 3 of 3

Excel 2007 : Extracting a point in a grid

Threaded View

Weezy Extracting a point in a grid 02-17-2010, 12:30 AM
Paul Re: Extracting a point in a... 02-17-2010, 12:53 AM
Weezy Re: Extracting a point in a... 02-17-2010, 11:28 AM
  1. #1
    Registered User
    Join Date
    02-16-2010
    Location
    Centrl Florida
    MS-Off Ver
    Excel 2007
    Posts
    28

    Extracting a point in a grid

    Well i feel like a dummy on this one. I would under normal circumstances think of myself as a expert in excel but this formula has got me stumped.

    My goal is to take two points of a grid of values and return the intersecting data. this is a little diffrerent than saya month/year lookup where youa re looking up say June of 2009 to see the total sales.

    what i am trying to do is simplify how my colleagues do their work by creating a "template" for processing data. so lets get into it shall we?

    in column D we have a store number, in column A we have the corresponding store number and in column B we have the skus that are available at those stores. unfortuantely our system does not spit it out anyother way hence the reason why i am compiling in excel.

    in row 1 from column E on are the corresponding skus that i need to reference. my goal is to match the column E with each sku and if it exists place an X in the coorensponding cell.

    i.e. becuase store 1 has sku 7278203271 cell E2 would have an X... skipping forward to a situation where we would not have a X marked would be where store 1 does not have 7771115767 cell BP2 would be left empty.

    once i get each row (store) with a list of skus in a grid i will be able to complete my compiling.

    Thanks in advance for your help,

    if you have any questions tha tyou need help with feel free to contact me and I will assist.

    well i am not able to upload the file for some reason. please download it from here. http://www.indigorhayne.com/lookup_sheet.zip
    http://www.indigorhayne.com/lookup_sheet.zip
    Last edited by Weezy; 02-17-2010 at 12:32 AM. Reason: URl isnt working

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