Hi, I am trying to perform what I thought was a simple lookup of descriptions for SKU numbers. I am using Mac Office 2011. Please see the info and photo below for the details. Any help would greatly appreciated. Thank you.
wtf_formula.jpg
FIGURE 1:
Column A is over 8000 SKU numbers. Column B has the descriptions for that SKU
Column G is an assorted list of SKU numbers. I want to pull the descriptions for the SKU numbers in G and insert them into column H.
FIGURE 2:
Using VLOOKUP to search A3:B8071 for the value in G51. If searching for an exact match (“FALSE”) it will not find the value, even though an exact match is present in the array of data. The example SKU number “71-0287” is present in the array.
FIGURE 3:
If you drop the “FALSE” argument and look for an approximate match, it will pull the description from the SKU found just before the one you are looking for. The example SKU 70-5088 is populated by the SKU that comes just before it 70-5087.
Same results when searching by reference G51 or by the value inside G51 “70-5088”
No matter what SKU is applied to the formula the results are the same. Except in the few instances where there really is not a match. Both columns are formatted as text, I also tried as numbers. I applied the same theory to a =INDEX MATCH formula. Same results with the TRUE/FALSE argument. Tried the same set of lookup data copied from a excel sheet, and from an SQL query.
Stuck on stupid for two days messing with this. Any ideas?
Bookmarks