JumboCactuar
Well-known Member
- Joined
- Nov 16, 2016
- Messages
- 788
- Office Version
- 365
- Platform
- Windows
Hi,
when running this code to lookup criteria on just about 300 rows, excel hangs and this takes maybe 30 seconds
its to output value in Sheet1 column C where the 2 criteria match
any quicker way, sure there will be
thanks in advance
when running this code to lookup criteria on just about 300 rows, excel hangs and this takes maybe 30 seconds
Code:
=LOOKUP(2,1/((A9=Sheet1!A:A)*($E$1=Sheet1!E:E)),Sheet1!C:C)
its to output value in Sheet1 column C where the 2 criteria match
any quicker way, sure there will be
thanks in advance