Index / Match?

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
 
J

Jason Morin

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

Array-entered.

HTH
Jason
Atlanta, GA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top