ExcelBanter - Index / Match?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Index / Match? (https://www.excelbanter.com/excel-worksheet-functions/10252-index-match.html)

Excel 2000 ... Here we go.

TabSheet 1

Col C = PN
Col D = Op
Col E = my formula

TabSheet 2

Col B = PN
Col F = Op
Col E = Op Desc

I want formula in TabSheet 1 Col E to pull in "Op Desc"
from TabSheet 2 Col E.

I have been trying to use INDEX/MATCH, but bombing on all
my attempts ... However, since I am certain the issue is
with my Excel shortcomings ... I am once again turning to
the Magicians of this board ... Thanks ... Kha

=INDEX(TabSheet2!E1:E100,MATCH(C1&D1,TabSheet2!
B1:B100&TabSheet2!F1:F100,0))

Array-entered.

HTH
Jason
Atlanta, GA

-----Original Message-----
Excel 2000 ... Here we go.

TabSheet 1

Col C = PN
Col D = Op
Col E = my formula

TabSheet 2

Col B = PN
Col F = Op
Col E = Op Desc

I want formula in TabSheet 1 Col E to pull in "Op Desc"
from TabSheet 2 Col E.

I have been trying to use INDEX/MATCH, but bombing on
all
my attempts ... However, since I am certain the issue is
with my Excel shortcomings ... I am once again turning
to
the Magicians of this board ... Thanks ... Kha
.