Search

J

Juan

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?
 
B

Bryan Hessey

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)
 
Top