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?
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?
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)
Originally Posted by Juan
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks