I am looking to for a formula that will lookup across multiple tabs. I have done something very similar using the following formula:
=SUMPRODUCT(SUMIF(INDIRECT("'"&Tabs&"'!J:J"),$A5,INDIRECT("'"&Tabs&"'!L:L")))
using the above as an example for what i am trying to accomplish 'Tabs' are the tab references I am looking at; A5 is the reference number i am looking up, Column J is the list of reference numbers in every tab, Column L is the string of text I want to pull out.
Hi Cleric,
The topic is called 3D when it goes across multiple sheets. Read about the 3D functions that are available in Excel at:
https://support.office.com/en-us/art...2-787d0bc888b6
I don't see SumProduct() in this list.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Hi Marvin, The formula in my example works to make a sumif into a 3D formula. I am not trying to sumif, I am trying to lookup to pull a string of text.
Try searching for "3D LOOKUP".
Here are a few results that may help you:
https://sites.google.com/a/madrocket...ions/3d-lookup
https://www.myonlinetraininghub.com/...ultiple-sheets
If you would like more specific help, consider uploading a small representative sample of your data along with the desired result/s of a working formula/s.
Last edited by JBeaucaire; 12-26-2019 at 03:43 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks