How to search for a block of two adjacent cells from a table

[raala12]

hi,
I have a table like this

jane....kaser...highschool......A
jack....Anderson....college.....B
Jill....Lovin.....college.......C

I want to check if both jack and Anderson in a same row two adjacent cells.
If both jack+anderson in a same row adjacent cells
as per in my table it should return column 4 value (A).
can I use VLOOKUP?
is there another way ?
please note I want to search for a block of two adjacent cells in a table and return its forth column value.

thanks

[NBVC]

you can introduce a column before the names which concatenates the first and last names, then you can use Vlookup and look for the concatenated names...

or you can use a formula like this:

=INDEX($D$1:$D$10,MATCH(1,INDEX(($A$1:$A$10=X1)*($B$1:$B$10=Y1),0),0))

where X1 and Y1 contain the respective search items fro columns A and B....