Automatically populating data from Sheet 1 to Sheet 2 ONLY if certain criteria are met

Hi,

I've been combing through the forums and everywhere else online and can't quite seem to find the answers I'm looking for. I'm hoping someone can help! I have a spreadsheet of tables listed in order by the credit card user's name and the last 4 digits of their card number. Each table consists of a 6 month period of time (six rows) which calculates the overall average spending. The blue column shows the average spent each month (calculated against their monthly allowed spending limit), over six months. The orange column show the averages of the amounts of the highest single purchase made within that same month (again, based on a max. single purchased limit). I have attached an example to make it more confusing :-P

What I need is a second sheet to populate (and update) automatically with the following information ONLY if/when the following criteria is met:
1. The Full_Name and Last_4 of the user whose Monthly Purch% AND/OR Single Purch% is less than or equal to 25% OR is greater than or equal to 100% (using only the cells just to the right of "Total average over 6 month). Of course, if any of those criteria are met, I need BOTH the Monthly Purch% and Single Purch% to be listed after the person's Full_Name and Last_4.

In my attachment, Sheet 1 shows the data. Sheet 2 (in the same file) is set up to show what I want to populate (and how) IF the above criteria are met. Basically, we are assessing credit card risk and want to look at those are consistently spending below 25% of their open credit, or conversely, who are spending at 100% or above (made possible by making a phone call to our purchasing department for "one-time" purchase limit increase waivers, etc.)

Thank you!!

Oops. Sorry! Please ignore the "attached" image that doesn't have the percentages filled in for Paul or Patsy.

Thanks! I've already gone home from work for the day so I'll give a try tomorrow! :-)

Ford,

This is working better for what I need, but still no cigar. I hate to feel like I'm pestering, but what I'm hoping is that Sheet 2 will only populate IF the criteria are met. Right now, it's just plopping in a zero. In the end, this sheet could have approx. 2000 names, and I would hate for that much information to be interspersed with zeros or blank lines. I'm also wondering if there's a way to make the formula pull the user's name from, say, A2 and the last 4 of their card from B2, rather than having to go into my document and ad their names and card # to another line. I literally have 23000 lines of data to troll through in my original document and it would take me quite a while just to copy and paste that info to a seventh line.

Thanks again.