Hey guys.
I upgraded from Excel 2003 to 2013 Pro and I used this exact code to do my lookup and it worked.
=INDEX('[Trend lookup Oct 14.xls]VB SCRIPT'!C$2:C$183,MATCH(A13&E13,INDEX('[Trend lookup Oct 14.xls]VB SCRIPT'!A$2:A$183&'[Trend lookup Oct 14.xls]VB SCRIPT'!B$2:B$183,0),0))
Now it gives me all sorts of problems.
Please have a look at the attached screen shot.
If the screen shot could not be viewed the error states:
We found a problem with this formula. Try clicking Insert Function on the Formulas tab to fix it...........
Not trying to type a formula?
When the first character is an equal (=) or minus (-) sign, Excel thinks it's a formula:
you type: =1+1, cell shows: 2
To get around this, type an apostrophe (') first:
you type: '=1+1, cell shows: =1+1
Hope you guys can help me.
Thank you.
Bookmarks