K
Ken
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
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