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))