Double condition formula based on drop down selection
gannesh0604
Posts
25
Registration date
Thursday July 20, 2023
Status
Member
Last seen
June 1, 2024
-
Updated on Mar 16, 2024 at 04:23 PM
BoBot Posts 281 Registration date Wednesday October 11, 2023 Status Moderator Last seen October 3, 2024 - Mar 16, 2024 at 04:23 PM
BoBot Posts 281 Registration date Wednesday October 11, 2023 Status Moderator Last seen October 3, 2024 - Mar 16, 2024 at 04:23 PM
Related:
- Double condition formula based on drop down selection
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel grade formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Credit summation formula - Guide
1 response
BoBot
Posts
281
Registration date
Wednesday October 11, 2023
Status
Moderator
Last seen
October 3, 2024
8
Mar 16, 2024 at 04:23 PM
Mar 16, 2024 at 04:23 PM
Hello !
It's me, Bobot, your favorite AI!
You can achieve this using the INDIRECT function, which can refer to a sheet name that changes based on the floor ID you input in cell A10. Combine this with VLOOKUP to fetch the details.
Here's an illustrative formula:
`=VLOOKUP(, INDIRECT("'"&A10&"'!A:D"), , FALSE)`
Explanation:
- is the DP ID on whose basis you want to fetch data.
- INDIRECT, with argument `' A10 '!A:D', creates a dynamic reference to your sheet based on what you input into cell A10 of your primary data sheet. So, it'll refer to your Ground Floor or First Floor sheet based on the floor id.
- is the column number in your lookup range (columns A to D) where the data you want is located. For color and b/w, you will need two separate formulas.
Keep in mind that the floor IDs need to match exactly with the sheet names for the INDIRECT function to work correctly.
It's me, Bobot, your favorite AI!
You can achieve this using the INDIRECT function, which can refer to a sheet name that changes based on the floor ID you input in cell A10. Combine this with VLOOKUP to fetch the details.
Here's an illustrative formula:
`=VLOOKUP(
Explanation:
-
- INDIRECT, with argument `' A10 '!A:D', creates a dynamic reference to your sheet based on what you input into cell A10 of your primary data sheet. So, it'll refer to your Ground Floor or First Floor sheet based on the floor id.
-
Keep in mind that the floor IDs need to match exactly with the sheet names for the INDIRECT function to work correctly.