I have data arranged in two colums.
Column A Column B
DataBig DataBig'sValue
DataBig2 DataBig2'sValue
DataBig1300 DataBig1300'sValue
I want to search through the titles in Column A (DataBig) and output the corresponding value(DataBig'sValue) in Column B. The VLOOKUP function is too dumb because I have to have the exact value of the name (Databig) in Column A...I want to input "searchname" and search through the values in Column A and output Column A values and their corresponding Column B values that partially match the "search name".
PLEASE HELP.
Column A Column B
DataBig DataBig'sValue
DataBig2 DataBig2'sValue
DataBig1300 DataBig1300'sValue
I want to search through the titles in Column A (DataBig) and output the corresponding value(DataBig'sValue) in Column B. The VLOOKUP function is too dumb because I have to have the exact value of the name (Databig) in Column A...I want to input "searchname" and search through the values in Column A and output Column A values and their corresponding Column B values that partially match the "search name".
PLEASE HELP.