Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
=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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match, Index, Vlookup, Large....Help Please | Excel Worksheet Functions | |||
Match, Index, Vlookup, Large....Help Please | Excel Worksheet Functions | |||
Match & Index | Excel Worksheet Functions | |||
Find a match that;s not exact | Excel Worksheet Functions | |||
Vlookup, Index & Match | Excel Worksheet Functions |