Vlookup using arreys

[hudson andrew]

Hi all ,

this is quite simple but could not able to do on my own , its vlookup , I wanted for multiple columns at one go.

I have a code that could only give result for one column .

Please Login or Register  to view this content.

attached is the file for your reference .

[hudson andrew]

Point to be noted , data in Column " A " would change day to day .

[AB33]

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Try:

Please Login or Register  to view this content.

[hudson andrew]

Mate - this is awesome, this is what I was looking for , can you elaborate code for me , so that i will have a picture on what I was working .

[AB33]

Range("B2:B" & rownum).SpecialCells(12).Resize(, 7).FormulaArray
is the same as
Range("B2:H" & rownum).SpecialCells(12).FormulaArray

you are starting in column B and end up in H or column B stretch it by 7 takes you to column H

[hudson andrew]

John and AB33 ,

Thank you very much for the extra help you gave me so I could do my job effectively I know how busy you are, so I really appreciated the time you spent with me addressing my queries.

[JOHN H. DAVIS]

You're welcome Hudson. Glad to help out.