Posts by FarrahFarley

    Re: Vlookup to return one value from multiple columns


    Teresa,


    Assuming:
    Your input cell is Sheet1!A1 and your output cell is Sheet1!B1
    Your data is in Sheet2
    Sheet2!Column_A is your search key
    Sheet2!Column_I is 'First Name"
    Sheet2!Column_P is "Last Name"
    Your data range is Sheet2!Rows_5_thru_7 (that is the 'A5:P7' part below. Adjust your range to whatever you are using)


    Put the following formula in Sheet1!B1:


    Code
    =VLOOKUP(A1,Sheet2!A5:P7,9,FALSE) & " " & VLOOKUP(A1,Sheet2!A5:P7,16,FALSE)


    Is this what you were look for?


    Farrah