Not exactly sure what you are trying to do, but this might work:

B1:
=IF(A1="A",IF(ISNA(VLOOKUP(F1,G1:Y7,3,FALSE)),"",V LOOKUP(F1,G1:Y7,3,FALSE)),
"")
B2:
=IF(A1="B",IF(ISNA(VLOOKUP(E1,R1:T7,2,FALSE)),"",V LOOKUP(E1,R1:T7,2,FALSE)),
"")

Regards

Trevor


"karlo " wrote in message
...
Hi, i dont know if this is possible
Im trying to make a search option in excel using VLOOKUP and without
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 familiar
with VB either.


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