Hi there this is my first post, i can normally work thing out by going through the forums and tweaking my stuff but im stuck. here is the problem.

i have 3 formulas that work on their own
=IF(ISNUMBER(SEARCH("a",F23)),VLOOKUP(A23,Sheet2!$ A$1:$A$1000:Sheet2!$K$1:$K$1000,9,FALSE),"")

=IF(ISNUMBER(SEARCH("b",F23)),VLOOKUP(A23,Sheet2!$ A$1:$A$1000:Sheet2!$K$1:$K$1000,10,FALSE),"")

=IF(ISNUMBER(SEARCH("c",F23)),VLOOKUP(A23,Sheet2!$ A$1:$A$1000:Sheet2!$K$1:$K$1000,11,FALSE),"")

what i think they say is that if cell f23 contains "a" look up data from cell a23 and insert correct cell from sheet 2.

now this works well if only i didnt need to combine them

what i need is this

if f23 contains a do the vlookup in column 9 if b use column 10 if c use column 11 if 9,10&11 blank leave cell blank

what i came up with is

=IF(ISNUMBER(SEARCH("a",F27)),VLOOKUP(A27,Sheet2!$ A$1:$A$1000:Sheet2!$K$1:$K$1000,9,FALSE),IF(ISNUMB ER(SEARCH("b",F27)),VLOOKUP(A27,Sheet2!$A$1:$A$100 0:Sheet2!$K$1:$K$1000,10,FALSE),IF(ISNUMBER(SEARCH ("c",F27)),VLOOKUP(A27,Sheet2!$A$1:$A$1000:Sheet2! $K$1:$K$1000,11,FALSE),"")))

this works for a and b but not c and deos not leave blank brings up the answer to b.


please can anyone help