formula help, if cell contains cell, then result

[eringreene]

i need to know how to write the formula for:

if (cell) contains (cell), then (cell)

basically what i am looking to do is similar to a v-lookup but with tw
parameters.

HELP PLEASE :

 

[Frank Kabel]

Hi
not really sure but maybe if your lookup data is in column A+B and the
search value in cell C1 try
=VLOOKUP(C1,A1:B100,2,0)

 

[David McRitchie]

Question is certainly missing an example, in fact without
use of VLOOKUP in question it would almost seem
=IF(A1=B1,C1,"")

but for a double lookup or triple lookup there are some
examples in the bottom half of my VLOOKUP page that
incorporate VLOOKUP, INDEX, MATCH
VLOOKUP Worksheet Function
http://www.mvps.org/dmcritchie/excel/vlookup.htm
and of course more material in the Related References at
the bottom of that page.