i have 1 worksheet url's of 60 styles have multiple children styles different colors. for example: website/sh70_black_2.jpg, website/sh70_black_3.jpg, website/sh70_blue_1.jpg, website/sh70_blue_2.jpg, website/gn02_pink_2.jpg, website/gn02_pink_3.jpg, website/gn02_pink_4.jpg, website/gn02_yellow_1.jpg, website/gn02_yellow_2.jpg, website/gn02_yellow_3.jpg, website/gn02_yellow_4.jpg, website/gn03b_blue_1.jpg, website/gn03b_blue_2 (1).jpg, website/gn03b_blue_2.jpg, website/gn03b_blue_3.jpg, website/gn03b_gray_1.jpg, website/gn03b_gray_2.jpg, website/gn03b_gray_3.jpg, website/gn03b_gray_4.jpg, website/gn03b_red_1.jpg, and in inventory program, sku gn03b_red, gn03b_gray , on... "text column" in excel , separate sku color. how lookup 2 columns in excel , return value if second column matches (ie; color)? you can use index , match array formula(ctrl+shift+enter): =index(the column want return,match(1stlookupcol&2ndlookupcol,0))