Excel 2010 - Pre-Populate fields based on data validation

Hi all,

I hope you can help me.
I am building some KPIs for my company and I need something.

I have a table with around 20 entries.
This table is divided into 3 columns: Partner Name, Net Amount, Split

However, I would need this to be displayed as the following:
I would do a data validation on the partner name to have a drop down list. After, once for example Partner A is selected, the field net amount and split would automatically appear. Same if I select Partner B or C, etc.

Is this possible?

thanks a lot for your help
Artur

This is one way. Using vLookup
Data is on sheet Data
Table on sheet data is named PartnerTable
Try different values in cell A3 on Sheet1 via the dropdown (based on first column in table PartnerTable
Formula in A4 is =VLOOKUP($A3,PartnerTable,2,0)
$A3 = lookup value, PartnerTable = where data is stored, 2 is the second column in the table (= Net Amount) , 0 = exact match required