Sunline
Well-known Member
- Joined
- Oct 6, 2007
- Messages
- 701
- Office Version
- 2016
- Platform
- Windows
Hello all , looked over past posts and none seem to cover this .
I would like to turn if possible this function into a macro as i run this in 3 cols and is memory heavy and slow . i have 170,000 rows and growing weekly .
=IF(DO2="",0,VLOOKUP(DO2,Sheet2!$E$2:$F$43,2,0)) , return answer is in col FO2 .
This looks at col DO2 , if blank will return a zero , if it contains
1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,1=,2=,3=,4=,5=,6=,7=,8=,9=,10=,11=,12=,13=,14=,15=,16=,17=,B,D,F,LR,P,RO,U , then lookup sheet2 range $E$2:$F$43 and return
5 if 1 found in col DO2,10 if 2 found,15 if 3 found,20 if 4 found,25 if 5 found , etc up to 210 which would be for U if found in col DO .
Golly i hope i have finally asked all the right questions for once .
Thanks .
I would like to turn if possible this function into a macro as i run this in 3 cols and is memory heavy and slow . i have 170,000 rows and growing weekly .
=IF(DO2="",0,VLOOKUP(DO2,Sheet2!$E$2:$F$43,2,0)) , return answer is in col FO2 .
This looks at col DO2 , if blank will return a zero , if it contains
1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,1=,2=,3=,4=,5=,6=,7=,8=,9=,10=,11=,12=,13=,14=,15=,16=,17=,B,D,F,LR,P,RO,U , then lookup sheet2 range $E$2:$F$43 and return
5 if 1 found in col DO2,10 if 2 found,15 if 3 found,20 if 4 found,25 if 5 found , etc up to 210 which would be for U if found in col DO .
Golly i hope i have finally asked all the right questions for once .
Thanks .
