INDEX and MATCH formula problem

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

Hi all,

I have this formula which I am using to match a value un Sheet1 against
the first section of the value in Sheet2. This is the formula:

=INDEX(Sheet2!A1:E10,MATCH(A4,LEFT(Sheet2!A1:A10,6),0),1)

In Sheet1 the value is OP02.10000R and in sheet it is OP02.10000R.104.
It only works if i take off the OP02. at the beginning. What do I need
to do to my formula to make it work.

Your help is greatly appreciated! Thank You

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
http://www.ozgrid.com/Services/excel-software-categories.htm **
 
If I understand you correctly:

=INDEX(Sheet2!A1:E10,MATCH(MID(A4,6,6),MID(Sheet2!A1:A10,6,6),0),1)
 
Back
Top