Lets say we have a two column table that has column A as:
and so on...
I need to fill column B with size in each and every row from another worksheet in the same workbook where I have two columns. I have been able to use VLOOKUP to do this. The table array would look like this in column A on the second worksheet:
and so on...with column B having the size
It is a simple VLOOKUP for matching SKU's 1000, 2000, 3000 etc because it is an exact match but how do I do a partial text match to match the first part of the cell value or even search the cells for the matching partial string and place the proper value 10 for size for SKU's 1000, 1000-yellow, and 1000-white, what would be value 20 for 2000, 2000-yellow, and 2000-white and so on?