Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Array Help
Thank you for being there to help us,
Is it possible to have a formula in colmn B that will look at any three individual cells in the array C1:E3 and match them up to any one row from the array F1:H11, then display a cancatenation of three like cells from array F1:H11 in Colmn B? I hope this example comes through well enough for you. Thank you, Luke A B C D E F G H 1 1 6 3 3 5 9 2 0 0 1 7 4 4 3 100 9 8 5 1 0 0 4 2 1 3 5 6 4 3 6 168 1 6 8 7 1 6 4 8 3 3 4 9 4 4 4 10 950 9 5 0 11 8 8 7 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display an array of references | Excel Worksheet Functions | |||
How to multiply all cells in array by factor | Excel Discussion (Misc queries) | |||
Excel array formulas | Excel Discussion (Misc queries) | |||
Formula to list unique values | Excel Worksheet Functions | |||
VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) |