Using a Lookup table in VBA

This is a discussion on Using a Lookup table in VBA within the Excel Questions forums, part of the Question Forums category; Hi,
I need to pull data from one workbook into another based on a lookup table.
one workbook contains the ...

Using a Lookup table in VBA

Hi,

I need to pull data from one workbook into another based on a lookup table.

one workbook contains the lookup information. This is a projections workbook.- I need to pull data over to another workbook based on the report that is run. The report is created using VBA, so need to lookup the data in Column A of the Report Book and use the information from the projections book accordingly.

Re: Using a Lookup table in VBA

have you tried using the countif function in excel, as in typing the formula out in a cell, and seeing if it returns a value?
Click on the fx in the formula bar if you want to play with some of the values.
I'm guessing it's the 6 at the end, but I could be wrong. Try changing that tot a false, I believe a 1 or 0 will also work.