the_Intern
Board Regular
- Joined
- May 23, 2013
- Messages
- 59
Hi All,
My question is as follows:
I am trying to match all the values in Column A of Worksheet 2 with values in Worksheet 1 that may be in Columns A, N, P, or X
I want my formula to return the cell adjacent the matching cell so I have:
{OFFSET(INDEX(NamedRange, MIN(IF(NamedRange = A2, ROW(NamedRange))), MIN(IF(NamedRange = A2, COLUMN(NamedRange)))),0,-1)}
So aside from being an eyesore this actually works but excel crashes due to the huge volume of data in my named range.
Is there a way to run a match like this with multiple look-up columns without using array formulas? Something in VB perhaps?
My question is as follows:
I am trying to match all the values in Column A of Worksheet 2 with values in Worksheet 1 that may be in Columns A, N, P, or X
I want my formula to return the cell adjacent the matching cell so I have:
{OFFSET(INDEX(NamedRange, MIN(IF(NamedRange = A2, ROW(NamedRange))), MIN(IF(NamedRange = A2, COLUMN(NamedRange)))),0,-1)}
So aside from being an eyesore this actually works but excel crashes due to the huge volume of data in my named range.
Is there a way to run a match like this with multiple look-up columns without using array formulas? Something in VB perhaps?
