=IF($G2="Left",INDEX(Lookup!$B$2:$B$30,MATCH($A2,Lookup!$A$2:$A$30,0)), INDEX(Lookup!$C$2:$C$30,MATCH($A2,Lookup!$A$2:$A$30,0))) Yury Hi John, you can use the following formula in cell K2 =IF($G2="Left","ReplaceWithYourLeftyValue","ReplaceWithYourRightyValue")...
the third parameter in the function - "2" - indicates the column number enumerated from left to right in the lookup range that has the value to be returned. last parameter - "FALSE" - indicates you want to do exact match of the values in column G2 and the first column in the lookup...