Sign Up

Have an account?

Sign In

Don't have account,

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account?

You must login to ask question.

Need An Account,
Search
Ask A Question
Asked: In:

How do I return multiple columns in Vlookup?

James Smith

James Smith

  • New York, United States (US)
View Profile
How do I return multiple columns in Vlookup?

1 Answer

  1. Shanawaz khan

    • Hyderabad , India
    View Profile
    1. Select the cells (cells equal to the number of columns that you wish to fetch) where you wish to populate the VLOOKUP results.
    2. Next, without clicking anywhere else type the formula: VLOOKUP(“Florian”,A:D,{1,2,3,4},FALSE) in the Formula bar. …
    3. After this simply hit the Ctrl + Shift + Enter keys.
    • 0