Trying to get this formula to work
Any idea where i am going wrong??Please Login or Register to view this content.
Trying to get this formula to work
Any idea where i am going wrong??Please Login or Register to view this content.
Hello and welcome to the forum. Sharing nothing but a non-working formula isn't going to allow us to help you much.
Attach a small representative sample workbook along with the desired results (which you can enter manually) based on that data.
Make sure there is just enough data to demonstrate your need.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.To upload an Excel workbook, follow these steps:
1) Click on "Go Advanced"
2) Click on "Manage Attachments"
3) Click on "Choose File"
4) Choose your file and click on "Open"
5) Click on "Upload"
6) Click on "Close this window"
One thing that does strike me as wrong with the formula is your use of OR.
Should be something like:
Formula:Please Login or Register to view this content.
But as mentioned above, without a sample file or even a bit more of a clue on what's not working, it's difficult to guess.
BSB
Agree that a sample file will greatly help.
1. are there only 2 different ranges? If so, try...
=IF(K5=Sheet2!$A$32,INDEX(Sheet2!$B$7:$H$15,MATCH(F5,Sheet2!$A$7:$A$15,0),MATCH(E5,Sheet2!$B$5:$H$5,0)),INDEX(Sheet2!$B$21:$H$28,MATCH(F5,Sheet2!$A$21:$A$28,0),MATCH(E5,Sheet2!$B$19:$H$19,0)))
2. If the 2 MATCH ranges contain the same info though, you may be able to just use 1 index/MATCH with a test to see which ranges to use, then just add that value to the MATCH's
3. Consider using Named ranges, it may make it a bit easier
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
This has worked a treat!! Seems to be bringing back all the correct data.
I cant add a sample file due to the sensitive nature of this particular spreadsheet.
But thanks you legend!
Happy to help (assuming my suggestion worked for you)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks