if and Vlook up help please

Hi

I have one master Workbook and 5 Data Workbooks
I would like to perform a Vlookup from the Master workbook and return Values from the 5 Data Workbook

I need to get this argument work somehow on Master Data Workbook

on ColumnC

If Column B is January Then VLookup on Workbook1 return value on Colum 4
If Column B is February Then VLookup on Workbook2 return value on Colum 4
If Column B is March Then VLookup on Workbook3 return value on Colum 4
If Column B is April Then VLookup on Workbook4 return value on Colum 4
If Column B is May Then VLookup on Workbook5 return value on Colum 4

On ColumnD

If Column B is January Then VLookup on Workbook1 return value on Colum 5
If Column B is February Then VLookup on Workbook2 return value on Colum 5
If Column B is March Then VLookup on Workbook3 return value on Colum 5
If Column B is April Then VLookup on Workbook4 return value on Colum 5
If Column B is May Then VLookup on Workbook5 return value on Colum 5

I am not sure if I should try a Macro or Formula, it is 80K row documents so I need to make sure it is efficient

Thank you

Hi, I would think macro would work better as it would take an awfully long time (and perhaps file size) if you rely on vlookup instead. Just my 2cents' worth.

Originally Posted by crazyshoots

Hi, I would think macro would work better as it would take an awfully long time (and perhaps file size) if you rely on vlookup instead. Just my 2cents' worth.

Thanks for that, I know how to generate a Vlookup from a Macro

Please Login or Register  to view this content.

but I am not sure how to make the Array and Column Where values are returned from, variables, based on conditions of another Column

I believe a sample workbook will be really help for the guys around here.

20 samples data is good enough. Then highlight the column/cells where you want the value to be vlookup/macro to.

Hi bimo,

This shouldn't be too difficult.
If you can supply sample workbooks so we can see what data you are working with it might help.

Originally Posted by Excel_Guy02

Hi bimo,

This shouldn't be too difficult.
If you can supply sample workbooks so we can see what data you are working with it might help.

Here it is Guys.. Thank you very much for your inputs.