<div>
On your Associate Review sheet, you have #REF! errors in the formulas, these must be corrected for the VLOOKUP formulas on the Reviews sheet to work.
</div>


<div>
oops, sorry didn't read the question well enough!
</div>


<div>
What does &quot;last 20 entries&quot; mean? You only have 13 entries there now so it's not very clear. I assume you want the lowest down positionally, so if there are entries in Review sheet down to row 100 that your &quot;associate Review&quot; will show the last 20, i.e. rows 81 to 100.<br />
<br />
I think you have a more complex formula than you need - try this setup using a &quot;helper&quot; column. In Associate Review cell AE2 put this formula <br />
<br />
=MAX(0,COUNTA(Reviews!A:A)<wbr />-21)+ROWS(<wbr />AD$1:AD2)<br />
<br />
copy down to AE21<br />
<br />
Now in Associate Review A2 put this formula<br />
<br />
=IF(INDEX(Reviews!A:A,$AE2<wbr />)=&quot;&quot;,&quot;&quot;,IN<wbr />DEX(Review<wbr />s!A:A,$AE2<wbr />))<br />
<br />
and copy across and down to AA21<br />
<br />
Of course this will also pick up some errors from &nbsp;the Review sheet. If you want to hide the errors try the above (second) formula with IFERROR, i.e.<br />
<br />
=IFERROR(IF(INDEX(Reviews!<wbr />A:A,$AE2)=<wbr />&quot;&quot;,&quot;&quot;,INDE<wbr />X(Reviews!<wbr />A:A,$AE2))<wbr />,&quot;&quot;)<br />
<br />
Hide column AE if required, see attached<br />
<br />
regards, barry<br />
<a href="https://filedb.experts-exchange.com/incoming/2011/10_w41/510072/27383737.xlsx" target="_blank" class="file-inline" title="data lookup (402 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>27383737.xlsx</a>
</div>


27383737.xlsx

<div>
Hi,<br />
<br />
Thank you for your reply, but, this isn't exactly what I'm looking for. Let me try to explain a little more to clarify.<br />
<br />
This sheet is a method of tracking performance. I wanted it to show the last 20 performance reviews from one particular person. I don't want it to track every single reference created for every person. That's what the review tab is for. <br />
<br />
So, in the associate review tab, I want to be able to type in a name in D24. Cells A2-A20 are set to equal the name from D24. Once this occurs, I want it to pull data from the last 20 entries in the review tab from that particular person's name.<br />
<br />

</div>


formula-V3.xls

<div>
<div class="content wysiwyg-content">
Hi--<br />
<br />
I have a simple form where you fill out info, and it gets put in a review tab. Under &quot;associate review&quot; I want to be able to review the last 20 entries from the review sheet. And, I also have some reporting tabs.<br />
<br />
I can't get the formulas to work in the associate review tab to pull the proper data from the review tab. &nbsp;<a href="https://filedb.experts-exchange.com/incoming/2011/10_w41/509869/formula.xls" target="_blank" class="file-inline" title="formula (3.5 MB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>formula.xls</a>
</div>
</div>


formula.xls

Hi--

I have a simple form where you fill out info, and it gets put in a review tab. Under "associate review" I want to be able to review the last 20 entries from the review sheet. And, I also have some reporting tabs.

I can't get the formulas to work in the associate review tab to pull the proper data from the review tab.  

Problem with IF formula

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.