Using a Lookup table in VBA

[saschmeling]

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.

Any suggestions.

Thanks,
Scott

 

[dermie_72]

to use vlookup in VBA, you need to use:
Application.WorksheetFunction.CountIf

The structure is the same as in Excel. Vlookup(Lookup value,table,column,true/false)

Hope that helps with your development.

 

[saschmeling]

to use vlookup in VBA, you need to use:
Application.WorksheetFunction.CountIf

The structure is the same as in Excel. Vlookup(Lookup value,table,column,true/false)

Hope that helps with your development.

Know this is going to make me sound lost but kind of am on this.

Tried this Code- and it did not work;

Application.WorksheetFunction.CountIf(RC[-6],'[5100 Projections.xlsm]Database'!R1C1:R728C7,6)

Any suggestions?

Thanks,

 

[dermie_72]

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.

Hope that helps.

 

[dermie_72]

I think I may have it. When I gave you the first function, I put countif instead of vlookup.

Try:

Application.WorksheetFunction.VLookUp(RC[-6],'[5100 Projections.xlsm]Database'!R1C1:R728C7,6)