match number then find last number in row

[leem]

I'm lost and would appreciate any help that you can offer. One sheet 2 column B, I would like to populate the last number in the row from sheet 1 that matches the number in sheet 2 column A. As you can see the last number is not always consistent to the last column, which would be so much easier.

Sheet 1
Column A Column b Column c Column d Column e Column f
30538 70.00% 83.30% 80.00%
31575 53.30% 63.30% 63.30% 53.30% 53.30%
39235 80% 87% 90%
42599 80.00% 93.30% 80.00%
45316 20.0% 97.0%
45748 53.30%
46415 0.0% 0.0% 0.0% 0.0% 44.00%
47544 40.0%
48706 83.0%
50696 0.0% 0.0% 0.0% 0.0% 0.0%



Sheet 2 - results
Column A Column b
50696 0.0%
46415 44.00%
31575 53.30%
39235 90%
42599 80.00%
48706 83.0%
47544 40.0%
45316 97.0%
45748 53.30%
30538 80.00%

Thanks in advance.

[Jonmo1]

Try this in Sheet 2, B2 and filled down

=LOOKUP(2,INDEX(Sheet1!$B$2:$F$11,MATCH(A2,Sheet1!$A$2:$A$11,0),0))

This is assuming the values in columns B and to the right are all percentages (less than or equal to 100%)
If that's not a correct assumtion, then this would be more reliable.

=LOOKUP(9.99999999999999E+307,INDEX(Sheet1!$B$2:$F$11,MATCH(A2,Sheet1!$A$2:$A$11,0),0))

[ChemistB]

With data in B2:H100, Unique ID's in A2:A100

=INDEX($B$2:$H$100, MATCH($A$1, $A$2:$A$100,0), MATCH(9^99, INDEX($B$2:$H$100,MATCH($A$1, $A$2:$A$100,0),)))

Assuming unique ids in column A (no duplicates)

[leem]

Perfect - thank you!! I really appreciate the answer and your knowledge.

Michelle

[Jonmo1]

You're welcome.