Referencing Value from other workbook range for VLOOKUP function

[chergian]

Hi Everyone,


I have this code:

Please Login or Register  to view this content.

Is it possible that it will coded like this?

Set Table2 = Workbooks(=range("B").value).Sheets(=range("C").value).Columns(range("G").value)
and
Cells(Imp_Row, Imp_Col) = Application.WorksheetFunction.VLookup(cl, Table2, =range("F").value, False)


Thanks in advance

[FDibbins]

Why not just use the regular vlookup function/formula?

[xlnitwit]

Hi,

Your suggestion is pretty much the answer

Please Login or Register  to view this content.

is the correct syntax- note that you must supply a row number for each range.

[chergian]

Why not just use the regular vlookup function/formula?

Hi FD,

I want vba code because it has a lot of rows in the main report.

Thanks.

[chergian]

Hi,

Your suggestion is pretty much the answer

Please Login or Register  to view this content.

is the correct syntax- note that you must supply a row number for each range.

Hi xlnitwit,

There is no error in my whole code, however, it did not populate the data...

Here's my whole code:

Please Login or Register  to view this content.

Also attach my sample files.

[xlnitwit]

How could there be an error when you start all your routines with

Please Login or Register  to view this content.

The code should adjust for each row thus

Please Login or Register  to view this content.

note the other two workbooks need to be open.

[chergian]

Xln,

The code works on sheets 1 only of all file... other sheets like 2 and 3 didn't populate the data....

[xlnitwit]

I don't know what you mean. There is no code to populate any other sheets.

[chergian]

I don't know what you mean. There is no code to populate any other sheets.

Sorry for not being clear...

I mean the data of Sheet("2") of FILE-A-Y1 and Sheet("2") and Sheet("3") of FILE-B-Y1 did not included in the Main Report..

[chergian]

I've just got it...

with this line:

Please Login or Register  to view this content.

Thanks all...

[chergian]

One Problem, is there any way that it will not open the source workbooks before running the code? i have at least 12 workbooks to lookup...