From: Joodle on 16 Mar 2010 22:03 That's it! Thanks. I was trying to make it so much more complicated! "Teethless mama" wrote: > In B1: =IF(A1=1,"Apple","") > In C1: =IF(A1=2,"Banana","") > and so on... > > > "Joodle" wrote: > > > I want to lookup a value in a table, then return a value to a different > > column based on the result. > > > > For example: > > > > Sheet 1 has: > > > > col A > > ------ > > 1 > > 2 > > 3 > > 4 > > > > Sheet 2 (LOOKUP table) has: > > > > col A col B > > ------ ------ > > 1 Apple > > 2 Banana > > 3 Carrot > > 4 Date > > > > I want to write a formula in sheet 1 that says: > > > > if the value in col A is 1, enter Apple in col B > > if the value in col A is 2, enter Banana in col C > > if the value in col A is 3, enter Carrot in col D > > if the value in col A is 4, enter Date in col E From: Teethless mama on 16 Mar 2010 22:26 You're Welcome! "Joodle" wrote: > That's it! Thanks. I was trying to make it so much more complicated! > > "Teethless mama" wrote: > > > In B1: =IF(A1=1,"Apple","") > > In C1: =IF(A1=2,"Banana","") > > and so on... > > > > > > "Joodle" wrote: > > > > > I want to lookup a value in a table, then return a value to a different > > > column based on the result. > > > > > > For example: > > > > > > Sheet 1 has: > > > > > > col A > > > ------ > > > 1 > > > 2 > > > 3 > > > 4 > > > > > > Sheet 2 (LOOKUP table) has: > > > > > > col A col B > > > ------ ------ > > > 1 Apple > > > 2 Banana > > > 3 Carrot > > > 4 Date > > > > > > I want to write a formula in sheet 1 that says: > > > > > > if the value in col A is 1, enter Apple in col B > > > if the value in col A is 2, enter Banana in col C > > > if the value in col A is 3, enter Carrot in col D > > > if the value in col A is 4, enter Date in col E First  |  Prev  |