| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I pull the col. index value as well as row index value
Dear Friends,
I have got a table, like A B C RC1 2843768 FR LH STD RC2 FR RH STD RC3 RR LH STD RC4 RR RH STD RC5 2843769 FR LH DLX. RC6 FR RH DLX. RC7 RR LH DLX. RC8 RR RH DLX. RC9 2843770 FR LH LUX RC10 FR RH LUX RC11 RR LH LUX RC12 RR RH LUX RC13 2843771 FR LH SDLX RC14 FR RH SDLX RC15 RR LH SDLX RC16 RR RH SDLX Now in another excel file if I put the 'Col 'A' cell value (number of col A) as input then the result in subsequent cell would be the merge of col. B & col. C & in the next row the answer would be 2nd row index value & so on. like this B RC1 FR LH STD RC2 FR RH STD RC3 RR LH STD RC4 RR RH STD This all vlues in Pivot table, so can I access that ref. -- Thanks, Vikram P. Dhemare |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referencing multiple criteria to pull data | Excel Discussion (Misc queries) | |||
| How to automatically number an index column | Excel Worksheet Functions | |||
| cell color index comparison | New Users to Excel | |||
| Min formula not returning value from Index | Excel Worksheet Functions | |||
| index to a range of cells | Excel Worksheet Functions | |||
Threaded Mode
