more lookup trouble

[jocabeana]

i know there's a way to look up say the second identical value in column
A, i just saw it on here last night. now i can't find it. can anyone
help me out.
for example
column A is my style numbers for products. then i have 5 or more rows
of descriptions.
then the las row is the price in let's say column F.
what i want to do is put the style number in column A again on the same
row as the price in column F and have a formula that will find the
second occurance of the same style number and return column F
any help would be appreciated as usual.
hope that's not to complicated
jason

 

[Arvi Laanemets]

Hi

At best you keep all data for one style in single row - so you'll have no
problems with current task, and with a lot of future ones too. I don't see
any reason you have additinal rows there anyway. You can freely have 5 or 7
or whatever columns for descriptions, when you must have them in separate
cells. And when you simply want descriptions be ordered row-wise, then you
can format the cell to 'Wrap text' (FormatCells.Alignment), and use
Alt+Enter to force a new row in cell - you are only limited to 255
characters in single cell.