tweeking excel numbers?

tweeking excel numbers?

I am trying to compare a price list to the cost I have in my system. The problem is they compare by upc code as the two are not in order, that and there are items in the price sheet not in my cost sheet, and the price list upc is 13 digits eg 2230112949128, where as my cost sheet have only 12 digits, eg 223011294912. Is there a way to tweek the price list to remove the 8(13th digit?)
Basically the lookup program I made uses vlookup from the UPC from cost sheet, comparing against the UPC from the price sheet, if the match is found, it copies the price onto my cost sheet so that I can compare the two prices.

Thanks in advance.

Tags: , ,

Under Forum

1 Comment for tweeking excel numbers?

  • 1. IXL@XL  |  February 15th, 2011 at 8:00 am

    Col A are UPC codes on both sheets
    On Cost sheet enter in C2 (1st data cell)
    =INDEX(Price!B:B, MATCH(LEFT(A2,12),A:A,0))
    Do your comparisons between cols C&B

Leave a Comment for tweeking excel numbers?

You must be logged in to post a comment.

Trackback this post  |  Subscribe to the comments via RSS Feed

Categories