Forum Discussion
Need help in Excel Formula
Hi, Suppose I have two hundred thousend rows. Each row has car model entries. I would like to write a formula in column B to determine only the model column A belongs to. The formula will just lo...
Thanks for the reply. No i dont need to extract the left string only. The model name is randomly positioned. It could be in the middle or right. Thats why i need a search function?
If list of models is in column E as here
that could be array formula (Ctrl+Shift+Enter)
=INDEX($E$1:$E$3,MATCH(1,--ISNUMBER(SEARCH($E$1:$E$3,A1)),0))
and attached