Hi all,
I've been trying to search for answers to this for some time but can't quite find the exact solution. I've seen other suggestions on the internet that many replied working well, but I just couldn't get it working.
Maybe I'm missing some simple steps but would appreciate all the help I can get.
I'm trying to lookup the cell in column A in "Data" sheet, to see if the cell contains value indicated in column A in "Keyword" sheet, if so, return the value stated in column B in "Keyword" sheet.
After I've solved that, I would adjust the formula so that if it can't match anything, return "Unknown" rather than returning an error. (obviously i haven't got to that part yet............)
Attached is the sample.
Thanks in advance!
View attachment Vlookup partial text in cell.xlsx
I've been trying to search for answers to this for some time but can't quite find the exact solution. I've seen other suggestions on the internet that many replied working well, but I just couldn't get it working.
Maybe I'm missing some simple steps but would appreciate all the help I can get.
I'm trying to lookup the cell in column A in "Data" sheet, to see if the cell contains value indicated in column A in "Keyword" sheet, if so, return the value stated in column B in "Keyword" sheet.
After I've solved that, I would adjust the formula so that if it can't match anything, return "Unknown" rather than returning an error. (obviously i haven't got to that part yet............)
Attached is the sample.
Thanks in advance!
View attachment Vlookup partial text in cell.xlsx