Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
index match
A B C D
ROW 5 1 65 6 56 ROW 6 2 100 7 41 ROW 7 3 34 8 32 ROW 8 4 6 9 43 ROW 9 5 8 10 5 I have 4 columns as above in one sheet, I want to match the numbers 1 to 10 and return the values in the column matching the number in another sheet as below. Please note, the above format changes on a daily basis as it comes from a web query e.g tomorrow there might only be 8 numbers, in which case 5 in A9 will move to C5 and A9 and C 9 will then be blank. A B ROW 5 1 65 2 100 3 34 4 6 5 8 6 56 7 41 8 32 9 43 Row14 10 5 The formula should be in B5 through B14 , is this possible? Thanks. Anthon. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
index(match) Wind Uplift Calculations (match four conditions) | Excel Worksheet Functions | |||
index Match, or Vlookup Match.. | Excel Worksheet Functions | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
How do I display more than one match in a Index/Match formula? | Excel Worksheet Functions | |||
index,match,match on un-sorted data | Excel Worksheet Functions |