I'm needing to pull info from different worksheets based on the text description located in cell A. On my Master Sheet I want to pull the number values in cells B and C only if the Text matches on the Description in Column A? There are variances in what cells some of these descriptions can be depending on the worksheet I'm pulling from.
Attached example:
Last edited by jakke655321; 05-28-2014 at 02:06 PM. Reason: formatted wrong
Try this formula in B2:
Formula:
=INDIRECT("'" & TEXT(B1,"mmm yy") & "'!" & "C10")
Perhaps something like this?
May be getting close, but Azumi yours is a perfect example of the issue i'm running into. See how the data you pulled into the Master is essentially "off" one line? For ex. for "Fees" in Dec-12 it actually pulled "Positive Bal" totals. Sometimes depending on the month the description won't be in the same place everytime. I'm still playing with the first formula K64. Thank you both for trying.
Sorry Azumi, I just noticed you removed the duplicate "positive balance" row I had in there...I think that does work!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks