Hello,
Lets say we have a two column table that has column A as:
SKU
1000
1000-yellow
1000-white
2000
2000-yellow
2000-white
3000
3000-yellow
3000-white
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:
SKU
1000
2000
3000
and so on...with column B having the size
10
20
30
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?
Bookmarks