How do I get the last number from a specific column
Hi!
Try this:
Assume your table is in the range A1:En
G1 = producer number
=LOOKUP(9.99999999999999E+307,OFFSET(A1,,MATCH(G1, A1:E1,0)-1,65536))
Note: 65536 refers to the size of the entire column where a match is found
of the producer number. This can be reduced to more reasonable number. If
there are no empty cells within the table you could use something like:
=LOOKUP(9.99999999999999E+307,OFFSET(A1,,MATCH(G1, A1:E1,0)-1,COUNTA(A:A)))
Biff
"milktruck" wrote in message
...
I have my producers listed across the top of my spreedsheet, they are
listed
by their producer number, and their pounds are listed below, sample below
220000 223300 456700 345400 675400
3300 4500 4501 2345 3456
4567 2345 6754 5678 2343
Below this I would like to enter a producer number and I want the computer
to give me the last pounds listed for that producer. Can anyone help me?
22300 result
|