MrsFraser07
New Member
- Joined
- Aug 16, 2017
- Messages
- 44
- Office Version
- 365
- Platform
- Windows
- MacOS
Hi there,
I have a very slow spreadsheet that is fairly formula intensive. It is alot of two-way lookups. I'm thinking that VBA code would speed things up, but I have no idea how to do that. Here is an example of one of my two-way lookup formulas:
{=IFERROR(INDEX(Sheet1!F:F,MATCH(A2&$F$1,Sheet1!A:A&Sheet1!D:D,0)),0)}
So, basically I want to return a value in column F from Sheet1 that matches cell A2 and F1 in columns A & D in Sheet1. I want the lookup in cell F1 to stay absolute, but the lookup in A2 to go down the list ie. A3, A4, A5, Etc. until it gets to the end of my column.
Hope that makes sense. I wish I could attach my spreadsheet, but I don't see an attachment upload. Thanks in advance for your help!
Shari
I have a very slow spreadsheet that is fairly formula intensive. It is alot of two-way lookups. I'm thinking that VBA code would speed things up, but I have no idea how to do that. Here is an example of one of my two-way lookup formulas:
{=IFERROR(INDEX(Sheet1!F:F,MATCH(A2&$F$1,Sheet1!A:A&Sheet1!D:D,0)),0)}
So, basically I want to return a value in column F from Sheet1 that matches cell A2 and F1 in columns A & D in Sheet1. I want the lookup in cell F1 to stay absolute, but the lookup in A2 to go down the list ie. A3, A4, A5, Etc. until it gets to the end of my column.
Hope that makes sense. I wish I could attach my spreadsheet, but I don't see an attachment upload. Thanks in advance for your help!
Shari