formula help, if cell contains cell, then result

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)

--
Regards
Frank Kabel
Frankfurt, Germany


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
two parameters.

HELP PLEASE


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

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.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Frank Kabel" wrote ...
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)

"eringreene " wrote
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
two parameters.

HELP PLEASE