Nothing happenedAttached
Thanks Khalid That's exactly I was looking for.Hello Phaneesh, welcome to the forum
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.
You are welcome dear.Thanks Khalid That's exactly I was looking for.
U have to change the number in the orange cell - 1/2/3/4 to change sheet referenceNothing happened
hi Khalid what if the values are not there in the same coloum or row in each worksheet?Hello Phaneesh, welcome to the forum
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 Chirayu.U have to change the number in the orange cell - 1/2/3/4 to change sheet reference
You can use the INDEX like: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.
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.This INDEX formula not working.
I am attaching the actual file. the yellow highlighted area has the valueThere 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?