Hi, i dont know if this is possible
Im trying to make a search option in excel using VLOOKUP and withou
using controls.

Lets say A1 can either be "A" or "B" (using validation list)

if A1="A"
B1=" " (this is currently the search box)
B2=VLOOKUP(E1,R1:T7,2,FALSE) -simply a formula

now if A1="B"
B1=VLOOKUP(F1,G1:Y7,3,FALSE)
B2=" " (this is now the search box)

I dunno if its possible, and if it is what should i do? im not familia
with VB either

--
Message posted from http://www.ExcelForum.com