user1301428 February 2016
How to use a VLOOKUP to get a column value based on another column value?
I have two Excel sheets, the first one looks like this:
And this is the second one:
Basically, I would like to fill in the column Value in the second sheet with the text from the Answer Column in the first sheet, but only when the value of the Question column is 3.
If there was no condition involved, I would simply use a VLOOKUP and be done, but is it possible to do a conditional VLOOKUP like this?
Sixthsense February 2016
In J2 Cell of Sheet2
Array formula requires CTRL+SHIFT+ENTER instead of normal enter.
Asked in February 2016
Viewed 2,607 times
Answered 1 times
Leave an answer
Quote of the day: live life