=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
.
|