Why don't you show an example of the the data and result you want, because
if the data cells you are searching are on row 1 and you want the matching
data on row 2, you need a different formula than if the search cells are in
column B and the values you want returned are in column A. Also if you are
searching for the a cell containing the text X in a cell containing something
like ABXCD then the approach will be different. If you are trying for and
exact match or just an approximate match the technique will be different. If
you are trying to do a case sensitive search then yet different issues must
be handled.
You could use VLOOKUP, LOOKUP, HLOOKUP, MATCH with INDEX or OFFSET and
possibly many other approachs.
I used lookup but had a formula for both B and C. I thought there might be
a way to do it with one formula. I wrote: =LOOKUP(C399,$C$2:$C$390,E2:E390)
where
C399 is where I input a value for A, c2:c390 is the range for the input to
lookup, and E2:E390 is the range to lookup B. there is a similar formula to
find C
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.