Get instant live expert help on I need help with excel refer to another sheet

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

=IFERROR(VLOOKUP(H13,'S:\Accounting\Gift Detail\[FY17_Gift_Detail_ReconSheets_Sept16-Aug17.xlsx]Table'!$B$4:$C$84,2,FALSE),"") I need this type of formula, but to reference sheet in present excel sheet NOT another sheet in another location. I am trying to refer it to the table in the sheet working on
Solved by G. L. in 15 mins
How to refer a Cell address derived from formula within another formula
Solved by V. J. in 23 mins
I'm looking for a way to auto refresh a sheet which has filters in it. It is base off another sheet so when info changes in it I would like the pother sheet to refer based off the filter.
Solved by G. H. in 16 mins
Please refer attached sheet and do needful to update formula
Solved by A. D. in 25 mins
how do i put below condition in one cell. 1. if Dzn than it refer 12 2. If yds than it refer to 36 3. If Pcs than it refer to 1
Solved by X. Q. in 20 mins