Data from tables to be brought on sheet

**beseda2004** · 03-16-2012, 03:51 PM

Hello.
I am having troubles (due to lack of programming skills) with following situation.

My question is how to bring uniform from the "Loan" sheet into "Cadet search" sheet into the table which is marked as "Equipment on Loan"
The data to be brought is dependent on Cadet's Surname + Cadet's ID

Regards, Vlad

**JBeaucaire** · 03-16-2012, 07:31 PM

E12: =IF(COUNTIF(Loan!$B:$B,$C$11)>=ROW($A1),INDEX(Loan!C:C, MATCH($C$11, Loan!$B:$B, 0) +ROW($A1)-1), "")

Now copy that formula down and across to column F. I presume prices will be coming from elsewhere?

**davesexcel** · 03-16-2012, 08:34 PM

Here is your attached back.
It is now a macro enabled workbook.
Select a cadet, click the button the get the info.
The assumption is that surnames may be the same but cadet numbers will only be assigned to one cadet.
I added a price column just because you did not have one in your example.
Play around with it,you will want to add a code to delete the info range.
You can use your macro recorder for that.
You can right click on one of your own buttons to assign the macro to it.

Happy coding.

**beseda2004** · 03-17-2012, 04:58 AM

2 davesexcel
Thanks, works great.
One more question - how would I make it bring up Item and quantity?
I was planning to have VLOOKUP to find the price from another table ( not included in my sample)