InfoPath Dev

Hi,

 So what I am trying to do right now is set up a rule to autofill 2 fields from one dropdown that is a selection from a sharepoint list. Filling one field is easy using the vLookup simulating trick but I can't figure out how to do two.

Here is a visualization of if the system was working properly:

Field 1:

Display: Column A of the sharepoint list. (Let's say the user picks X for simplicity)

Value: Column B of the list.

Rule: When filled, fill field 2 with Column B row X by saying "Write this value with '.' "

Rule2: When filled, fill field 3 with column C Row X 

Field 2: Now contains the correct value that is Column B Row X.

 Field 3: Displays the value from Column C Row X.

My question is how I implement Rule2. I can't say   xPathtoList/@ColumnC     because that is only returning the first row of Column C now row X. Is there a way in xPath or otherwise to say pull the value from Column C at row X?

Thank you!

For Rule2, you want to set Field 3 equal to Column C in the SharePoint list with the following filter on C: Column B is equal to Field 1.