Hello,
I am using excel and i wanted to do a formula that matches back the cheque # and cheque amount.
For example :
A B C D E F
bank $ cash book $
3450 $200 3449 $120
3451 $150 3450 $200
2453 $250 3451 $150
3452 $95
3453 $255
i want to match back columns A & D and column B & E in one formula. Can the formula match back the $ value like how the bank cashed cheque 2453 as $250 and the cash book has the correct figure which is cheque 2453 for $ 255. ( the bank undersated the customer). Can i get answeres like what i have in Column F?
A B C D E F
bank $ cash book $
3450 $200 3449 $120 not found
3451 $150 3450 $200
2453 $250 u/s 3451 $150
3452 $95 not found
3453 $255
Add data to columns with userform data excel Cant find match cod Count the number each unique value appears in a column Counts number same rows different columns Excel 2007 add data to columns with userform Excel column date reminder outlook Excel formula for cells that do not match Excel formulas count data in one column with 2 criteria Excel match macro Excel show only what matches in two columns Excel two columns count number of rows with matching values How select particular column using if condition How to count column in excel using code Macros to write to excel columns Match any in 2 columns excel Match columns excel Matching columns in two different file See what two columns match