YasserKhalil
10-28-2016, 04:10 AM
Hello everyone
I need to lookup part of string in three columns and retrieve data related to it
I have attached sample workbook ..
In sheets("Main") I need to search for SKU in column C for example : "FNYD024-05XL" >> search for the first part only which is "FNYD024" ..
This is in row 110 in sheets("Table") ... The search would be in three columns B & C & D in sheets("Table")
If found take the values in both columns E & F
If possible I need to do the task using VBA arrays
Thanks advanced for help
I need to lookup part of string in three columns and retrieve data related to it
I have attached sample workbook ..
In sheets("Main") I need to search for SKU in column C for example : "FNYD024-05XL" >> search for the first part only which is "FNYD024" ..
This is in row 110 in sheets("Table") ... The search would be in three columns B & C & D in sheets("Table")
If found take the values in both columns E & F
If possible I need to do the task using VBA arrays
Thanks advanced for help