• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Data and formula selection based on the selection made....

Phaneesh

New Member
Hi
I am Phaneesh, I am a senior project manager in a interior firm. I need help on how to select the data from the relevent worksheet based on the selection made in Source sheet
 

Attachments

  • Project calculation.xlsx
    10.1 KB · Views: 3
Hello Phaneesh, welcome to the forum :awesome:
If I understood you correctly, you can use the INDIRECT

See the attached Example

Regards,

Edit: Chirayu u beat me by a minute. Didn't noticed u replied.
 

Attachments

  • Project calculation.xlsx
    10 KB · Views: 5
Hello Phaneesh, welcome to the forum :awesome:
If I understood you correctly, you can use the INDIRECT

See the attached Example

Regards

Edit: Chirayu u beat me by a minute. Didn't noticed u replied.
hi Khalid what if the values are not there in the same coloum or row in each worksheet?
 
Ok. If criteria is in different columns then you'll need to attach a sample file so I can modify my formula. See if its possible. Probably use Index Match
 
hi Khalid what if the values are not there in the same coloum or row in each worksheet?
You can use the INDEX like:
=INDEX(INDIRECT("'"&A$1&"'!C3:C99"),MATCH(A5,INDIRECT("'"&A$1&"'!A3:A99"),0))

You have the match part for row, so it can be found anywhere in row.
No clue for the columns.
 
You can use the INDEX like:
=INDEX(INDIRECT("'"&A$1&"'!C3:C99"),MATCH(A5,INDIRECT("'"&A$1&"'!A3:A99"),0))

You have the match part for row, so it can be found anywhere in row.
No clue for the columns.

This INDEX formula not working.
 

Attachments

  • Project calculation.xlsx
    10.7 KB · Views: 4
This INDEX formula not working.
No dear, I said it will work for the row part, not for the column part as we don't have any matching values for columns.
like we have matching values for row in your column A.

See the attached, and check the rows of other sheets.
 

Attachments

  • Project calculation.xlsx
    12.5 KB · Views: 1
There may be a workaround for the column part but I need to know a few things first to check if its possible
1) A is always where product name is?
2) What is the last column that will have data?
3) Are there any other values between the columns when the price changes column? as in If Price is in C, then are other columns blank apart from Product column A?
 
There may be a workaround for the column part but I need to know a few things first to check if its possible
1) A is always where product name is?
2) What is the last column that will have data?
3) Are there any other values between the columns when the price changes column? as in If Price is in C, then are other columns blank apart from Product column A?
I am attaching the actual file. the yellow highlighted area has the value
 

Attachments

  • Copy of BEDROOM COSTING FINAL.xlsx
    408.9 KB · Views: 4
Looking at your data. I'm guessing it was a PDF that was converted to Excel. Unfortunately because of that there is no way that a formula could do what you want. The reason being that the Prices change columns within the same sheet as well as different sheets. There is no specific header to match it against either. You will have to format your data for any formula to work.
 
Back
Top