Is it possible to make a search fomula that searches column a for the text entered in E1 and displays the data listed in adjacent comumns.
eg. I look up cars and it looks for cars in column A when it finds the result say A12 it displays the data in B12,C12,D12,E12 as well.
so A12 displays in F1, C12 in G1 and so on