Hello!
Can anyone help me find the right formula for what I need?
I have multiple sheets that has a continuous name starting from 100 to 200.
I'm currently using a formula to show the sheet name inside the work page in one of the cell. (see below in 2nd sheet corner "sheet 100" is the sheet name and so on)
I'm trying to use 1 sheet to input all the information and have the rest of the sheets from 100 to 200 receive information. This sheet is called INFO SHEET
I need it to match the sheet name, the fruit and size and return value.
EXAMPLES BELOW.
______________________________________________________________________________________
INFO SHEET BELOW.
2ND SHEET BELOW (WHERE IT NEEDS THE FORMULA)
Thank you!
Can anyone help me find the right formula for what I need?
I have multiple sheets that has a continuous name starting from 100 to 200.
I'm currently using a formula to show the sheet name inside the work page in one of the cell. (see below in 2nd sheet corner "sheet 100" is the sheet name and so on)
I'm trying to use 1 sheet to input all the information and have the rest of the sheets from 100 to 200 receive information. This sheet is called INFO SHEET
I need it to match the sheet name, the fruit and size and return value.
EXAMPLES BELOW.
______________________________________________________________________________________
INFO SHEET BELOW.
sheet 100 | sheet 101 | sheet 102 | ||
apple | small | 2 | 1 | 7 |
apple | medium | 4 | 3 | 9 |
apple | large | |||
orange | small | |||
orange | medium | |||
orange | large | 9 | ||
pear | small | |||
pear | medium | |||
pear | large |
2ND SHEET BELOW (WHERE IT NEEDS THE FORMULA)
sheet 100 | |||||
small | medium | large | |||
apple | (need formula to find value of 2 from info sheet) | (need formula to find value of 4 from info sheet) | | ||
orange | | | (need formula to find value of 9 from info sheet) | ||
pear |
Thank you!