Thread: Index / Match?
View Single Post
  #1   Report Post  
Ken
 
Posts: n/a
Default Index / Match?

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