formula help, if cell contains cell, then result

  • Thread starter Thread starter eringreene
  • Start date Start date
E

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 :
 
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)
 
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.
 
Back
Top