Eddie,

Array enter (enter using Ctrl-Shift-Enter) the formula

=IF(COUNTIF($I$1:$I$384,$B$78)=ROWS($A$1:A1),INDE X($K$1:$K$384,LARGE(($I$1:$I$384=$B$78)*ROW($I$1:$ I$384),COUNTIF($I$1:$I$384,$B$78)-(ROWS($B$1:B1)-1))),"0.00")

And copy down for as many rows as you need.

HTH,
Bernie
MS Excel MVP


"eddie d" <eddie wrote in message
...
I have a "template" set up in a worksheet so I can review data in the same
format daily. I import data to the sheet and the "template" finds the data
and puts it in the right order/format as the import comes in formated
slightly different daily. I use vlookup to find the refrence and
subsequently
populate the data/template. I have a few lines that have the same
reference
name. The first name works as it supposed to, The second name gets
populated
with the first names' data as it finds it first. I need the second name
to
to find the second reference and the third to find the third can anyone
help.
Here is the vlookup formula I use and works great...cant even tell you
how
I got it to work it as I am a beginer with this.

=IF(ISNA(VLOOKUP($B78,I$1:N$384,3,FALSE))=TRUE,"0. 00",VLOOKUP($B78,I$1:N$384,3,FALSE))