Turn an Excel Vlookup Formula into a Macro

[Steve Strunk]

Hi All

I wrote an excel formula using vlookup, I added in a conditional statement so the formula would not display N/A. Here is the formula:

=IF(ISNA(VLOOKUP(A2,'T:\EHS\Chemical Inventory\2011\2011 Chemical Inventory Final+Cost Center\[Hazard Table.xls]Hazardous Chemicals'!$A$4:$B$488,2,FALSE)),"", (VLOOKUP(A2,'T:\EHS\Chemical Inventory\2011\2011 Chemical Inventory Final+Cost Center\[Hazard Table.xls]Hazardous Chemicals'!$A$4:$B$488,2,FALSE)))

I would like to put this into a Macro so I could add a button to make it easier to use because I have to use this frequently with thousands of chemicals that come in every day.

Please Login or Register  to view this content.

Any help would be appreciated

Thanks

[Leith Ross]

Hello Steve,

Welcome to the Forum!

Here is the formula converted to a macro. The macro assumes "A2" is on the active worksheet, the code in the workbook named "Hazard Table.xls", and the look up sheet is named "Hazardous Chemicals".

Please Login or Register  to view this content.