B
Bob
I tried the INDEX function however I received an #N/A
error. Not sure if I'm typing it in correctly or not.
My table columns are J2:L4 and the data in the spreadsheet
are in columns M&P and I typed the function in column Q.
Here is what I typed:
=INDEX(Projects!$L$2:$L$4,MATCH(J2&K2,Projects!
$J$2:$J$4&Projects!$K$2:$K$4,0))
Thanks.
Bob
error. Not sure if I'm typing it in correctly or not.
My table columns are J2:L4 and the data in the spreadsheet
are in columns M&P and I typed the function in column Q.
Here is what I typed:
=INDEX(Projects!$L$2:$L$4,MATCH(J2&K2,Projects!
$J$2:$J$4&Projects!$K$2:$K$4,0))
Thanks.
Bob