Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup and concatenate
i would like to concatenate the data in column A with the top cell when going
across the row there is a quantitiy. For example A2 would match B1 giving me 'jonesAB1'. Possible? A B C D E F G 1 AB1 AB2 AB3 AB4 AB5 AB6 2 Jones 10 3 Smith 11 4 Wilson 10 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup and concatenate
Hi Greg,
try =IF(A2<"",A1&B1,IF(B2<"",A1&C1,IF(C2<"",A1&C1,I F(D2<"",A1&D1,IF(E2<"",A1&E2,""))))) if you have more than 7 columns to compare it won't work If this help you please rate it thanks "Greg" wrote: i would like to concatenate the data in column A with the top cell when going across the row there is a quantitiy. For example A2 would match B1 giving me 'jonesAB1'. Possible? A B C D E F G 1 AB1 AB2 AB3 AB4 AB5 AB6 2 Jones 10 3 Smith 11 4 Wilson 10 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup and concatenate
Eduardo,
bad news....I have about 85 columns to compare. Greg "Eduardo" wrote: Hi Greg, try =IF(A2<"",A1&B1,IF(B2<"",A1&C1,IF(C2<"",A1&C1,I F(D2<"",A1&D1,IF(E2<"",A1&E2,""))))) if you have more than 7 columns to compare it won't work If this help you please rate it thanks "Greg" wrote: i would like to concatenate the data in column A with the top cell when going across the row there is a quantitiy. For example A2 would match B1 giving me 'jonesAB1'. Possible? A B C D E F G 1 AB1 AB2 AB3 AB4 AB5 AB6 2 Jones 10 3 Smith 11 4 Wilson 10 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup and concatenate
=A2&INDEX($B$1:$G$1,MATCH(TRUE,INDEX(B2:G2<"",),) )
"Greg" wrote: i would like to concatenate the data in column A with the top cell when going across the row there is a quantitiy. For example A2 would match B1 giving me 'jonesAB1'. Possible? A B C D E F G 1 AB1 AB2 AB3 AB4 AB5 AB6 2 Jones 10 3 Smith 11 4 Wilson 10 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup and concatenate
Teethless mama,
Perfecto-O! Thanks, Greg "Teethless mama" wrote: =A2&INDEX($B$1:$G$1,MATCH(TRUE,INDEX(B2:G2<"",),) ) "Greg" wrote: i would like to concatenate the data in column A with the top cell when going across the row there is a quantitiy. For example A2 would match B1 giving me 'jonesAB1'. Possible? A B C D E F G 1 AB1 AB2 AB3 AB4 AB5 AB6 2 Jones 10 3 Smith 11 4 Wilson 10 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
I know how to concatenate ,can one de-concatenate to split date? | New Users to Excel | |||
Un - Concatenate? | Excel Worksheet Functions | |||
concatenate | Excel Worksheet Functions | |||
Concatenate | Excel Worksheet Functions |