With a table of counterfoils on Sheet2 being Column A having the
identifier, and Column B the amount, and with your identifier (cheque
numbers) in column A of this sheet, try

=vlookup(A1,Sheet2!a:b,2,False)





Juan Wrote:
I am trying to do a formula where it alludes to a column and a line and
returns me the value from a counterfoil.

How Made this formula?


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=490445