VLOOKUP for contents and formats using VBA

briannyc

New Member
Joined
Mar 15, 2011
Messages
1
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))
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
Colour coding is not data. Why don't you store a code reference with each row? You could retrieve that and colour your results dependent on that, if you need to.
 
Upvote 0

Forum statistics

Threads
1,213,549
Messages
6,114,261
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top