Re: Vlookup to return one value from multiple columns
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:
Is this what you were look for?