| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If and LOOKUP - results in multiple columns
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If and LOOKUP - results in multiple columns
Hi
The formula =VLOOKUP(A1,Sheet2!A:B,2,FALSE) -- Please click "yes" if this post helped you! Greatly appreciated Eva "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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If and LOOKUP - results in multiple columns
This formula placed all the results from the lookup in the same column.
I want the results such that all "Apple" are in col B, all "Banana" are in col C, all "Carrot" are in col D, and all "Date" are in col E. "Eva" wrote: Hi The formula =VLOOKUP(A1,Sheet2!A:B,2,FALSE) -- Please click "yes" if this post helped you! Greatly appreciated Eva "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: |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If and LOOKUP - results in multiple columns
Hi
I don't know what you want to accomplish, but try this =TRANSPOSE(VLOOKUP($A2,Sheet2!$A:$B,2,FALSE)) (it is array formula ctrl+shift+enter) -- Please click "yes" if this post helped you! Greatly appreciated Eva "Joodle" wrote: This formula placed all the results from the lookup in the same column. I want the results such that all "Apple" are in col B, all "Banana" are in col C, all "Carrot" are in col D, and all "Date" are in col E. "Eva" wrote: Hi The formula =VLOOKUP(A1,Sheet2!A:B,2,FALSE) -- Please click "yes" if this post helped you! Greatly appreciated Eva "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: |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If and LOOKUP - results in multiple columns
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If and LOOKUP - results in multiple columns
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If and LOOKUP - results in multiple columns
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup with multiple results | Excel Discussion (Misc queries) | |||
| Lookup with Multiple results | Excel Worksheet Functions | |||
| V lookup with 2 criteria to return results for multiple columns | Excel Worksheet Functions | |||
| single lookup value with multiple results | Excel Worksheet Functions | |||
| How can I do a lookup and get multiple row results? | Excel Worksheet Functions | |||
Hybrid Mode
