- Joined
- Sep 14, 2008
- Messages
- 5
- Reaction score
- 0
Here is a stumper for me. Maybe I am missing something. I have this VLOOKUP in Row H === =IF(IF(ISERROR(VLOOKUP(A1912,Data_2!$B$1:$L$57570,9,FALSE)),"None",VLOOKUP(A1912,Data_2!$B$1:$L$57570,9,FALSE))=0,"None",IF(ISERROR(VLOOKUP(A1912,Data_2!$B$1:$L$57570,9,FALSE)),"None",VLOOKUP(A1912,Data_2!$B$1:$L$57570,9,FALSE))). Which sorta works. What I need is this code with a concatanate or how ever you spell it in VBA for excel.
OR
I have 3 search criterias to verify from page 1 to page 2 if those 3 match returns the answer located in page 2 into page in the H location. The code on the IF Vlookup in each cell slows down the excel page way too much. There is 60000 records. So it needs to go all the way down the I column searching across.
Please help.
OR
I have 3 search criterias to verify from page 1 to page 2 if those 3 match returns the answer located in page 2 into page in the H location. The code on the IF Vlookup in each cell slows down the excel page way too much. There is 60000 records. So it needs to go all the way down the I column searching across.
Please help.