duplicate entries

[bullcreel]

I have a formula: =vlookup (park!$R$1&BI3,rtzca,2)

When I copy the formula down 10 rows, it will duplicate entries if rtzca had no more data to show. So, first 5 rows will be fine then rows 6-10 will show same exact data as row 5. Then I have to delete those duplicate rows. How do I stop that from happening?

 

[Foz1980]

Sorry, but what is rtzca?
That section of your formula should be your table array (so the table that you want to lookup).

 

[bullcreel]

Rtzca is just the tab where all the data is coming from. I used a name manager. The formulas work fine is just that it starts repeating itself when there is no additional data.

 

[Foz1980]

Ok I understand.
Next question though - the actual value you want looking up, am I right in saying this is always whatever is in cell R1 and BI3 on the sheet called 'park'?