Slickdeals is community-supported.  We may get paid by brands or deals, including promoted items.
8 results found matching
RSS
Filtering Options
Show results for
$ - $
Filters
Filters
Filters
excel Q
Expired
Thread created 01-26-2013 by BargainSnatcher
0 Score 7 Replies 546 Views
Post #57173044 added 01-27-2013 4:20 PM by Wasser in Archived Deals
You could also do an index-match instead of the vlookup. Generally it is a bit more flexible, no worries where your columns are located and such. So here is the formula you would enter in say row...
excel Q
Expired
Thread created 01-26-2013 by BargainSnatcher
0 Score 7 Replies 546 Views
Post #57170270 added 01-27-2013 1:39 PM by skrooks in Archived Deals
There are 2 requirements for VLOOKUP to work. 1. The lookup column needs to be before the data column. On sheet 2, the reference number column M is after the data column K. You'll need to have the...
excel Q
Expired
Thread created 01-26-2013 by BargainSnatcher
0 Score 7 Replies 546 Views
Post #57152508 added 01-26-2013 4:07 PM by BargainSnatcher in Archived Deals
Thanks. I'm totally inexperienced with excel and am not having much luck creating the vloopup formula. I was hoping someone here could tell me what i need as it will probably take me 1/2 the day...
excel Q
Expired
Thread created 01-26-2013 by BargainSnatcher
0 Score 7 Replies 546 Views
Post #57146088 added 01-26-2013 10:04 AM by chanle51 in Archived Deals
You can do it across two separate files - the only issue is that after you do the vlookup, if you delete or move the second file that the vlookup is referencing you will lose the data. If it's a...
excel Q
Expired
Thread created 01-26-2013 by BargainSnatcher
0 Score 7 Replies 546 Views
Post #57145158 added 01-26-2013 9:15 AM by skrooks in Archived Deals
You might try copying the contents of one file into the other as a new tab/page. I'm pretty sure you could do a vlookup across pages, but I don't know across files.
excel Q
Expired
Thread created 01-26-2013 by BargainSnatcher
0 Score 7 Replies 546 Views
Post #57145000 added 01-26-2013 9:05 AM by chanle51 in Archived Deals
Depending on how the file is laid out you could do a vlookup based on the unique codes.
excel Q
Expired
Thread created 01-26-2013 by BargainSnatcher
0 Score 7 Replies 546 Views
Post #57144858 added 01-26-2013 8:55 AM by komondor in Archived Deals
well is it safe to assume the 2 files have a different number of entries we talking a dozen or hundreds?
excel Q
Expired
Thread created 01-26-2013 by BargainSnatcher
0 Score 7 Replies 546 Views
Post #57142694 added 01-26-2013 6:52 AM by BargainSnatcher in Archived Deals
Not sure if this is the right forum. I have 2 seperate files, on one file i have current stock and in another all the stock i ever had. The file with all the stock i ever had has a column which has...

More Results from Amazon.com See more at Amazon

More Results from Walmart.com See more at Walmart

More Results from Ebay.com

Didn't find what you were looking for?

We're displaying limited results because of the following settings:

  • Deals with Any Rating
  • Deals from Any Time
  • Deals from 24 forums
  • Deals filtered by and
  • Searching within Entire Threads

If you want to relax this search, click here to reset all search parameters. You can also adjust them by using the filtering options on the left.