i need a formula that will look up a word then give me the numbers in a cell
next to that word. the formula i'm using (which isn't working right) is

=IF(ISERROR(VLOOKUP(A6,'Export
1'!$B$1:$Z$65467,11,FALSE)),"",VLOOKUP(A6,'Export 1'!$B$1:$Z$65467,11,FALSE))

this may be too much formula for what i need but i'm not sure... here's
what i'm actually trying to do. i would like to set up a check list or
something so when people select a certain row by adding a X, the following
information will auto fill onto another sheet...