Hello MrExcel!
Thanks for creating such a rich resource. I'm stuck on a project where I need to perform a lookup from one table with over 10,000 rows to another table with about 20,000 rows. The lookup table is color coded as it is an aggregation of several data sources and so it is important to keep the formats. I've researched for hours online and have only learned that VBA is required to perform this type of look up. Can you please let me know what script I would need to use to run this macro? The formula I'm using in the first row of data is below. Thanks!
=IF(ISNA(VLOOKUP(Z6,'Raw Data'!$A$1:$C$53987,3,0)=TRUE),"",VLOOKUP(Z6,'Raw Data'!$A$1:$C$53987,3,0))
Thanks for creating such a rich resource. I'm stuck on a project where I need to perform a lookup from one table with over 10,000 rows to another table with about 20,000 rows. The lookup table is color coded as it is an aggregation of several data sources and so it is important to keep the formats. I've researched for hours online and have only learned that VBA is required to perform this type of look up. Can you please let me know what script I would need to use to run this macro? The formula I'm using in the first row of data is below. Thanks!
=IF(ISNA(VLOOKUP(Z6,'Raw Data'!$A$1:$C$53987,3,0)=TRUE),"",VLOOKUP(Z6,'Raw Data'!$A$1:$C$53987,3,0))
