LinkBack URL
About LinkBacks
New Microsoft Excel Worksheet.xlsx
I want to copy the value in which is next to word Total in Petty Cash sheet to the cell next Petty cash cell in TB sheet.
what is the prober formula for that??
New Microsoft Excel Worksheet.xlsx
I want to copy the value in which is next to word Total in Petty Cash sheet to the cell next Petty cash cell in TB sheet.
what is the prober formula for that??
Last edited by amr7; 04-28-2015 at 10:11 AM.
Use this formula in C3 and copy down
=IFERROR(VLOOKUP(A8,Sheet1!$B$2:$G$100,5,0),"")
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
it does not working, I want to make "Total" in E100 in Petty cash sheet as my reference and copy the amount beside it in the other sheet
Last edited by amr7; 04-29-2015 at 03:34 AM.
A little confused, as the word TOTAL does not appear on sheet "Petty Cash". But, try this
IFERROR(INDEX('Petty Cash'!F$2:F$100,MATCH(TB!$A3,'Petty Cash'!$B$2:$B$100,0)),"") in C3 copied down (and across to give CR)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Total appear in cell E100
tried this formula, but it give me the total for one transaction not the total
I would never have thought of scrolling down 100 rows to find it!!!
Why not delete row 100 and use =SUM('Petty Cash'!F:F)
if you do want to keep it, why not use =SUM('Petty Cash'!F2:F99)
C8=INDEX(INDIRECT("'Petty Cash'!F:F"),MATCH(99^9,INDIRECT("'Petty Cash'!F:F")))
D8=INDEX(INDIRECT("'Petty Cash'!G:G"),MATCH(99^9,INDIRECT("'Petty Cash'!F:F")))
E8=INDEX(INDIRECT("'Petty Cash'!H:H"),MATCH(99^9,INDIRECT("'Petty Cash'!F:F")))
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks