Dec 09 2022 02:51 AM
Based on the frequency and voltage the values should be taken from the table.
Dec 09 2022 04:32 AM
Here are two links that might help you in your project.
How to combine transpose function and If statement function in Excel?
Look up values with VLOOKUP, INDEX, or MATCH
Hope I was able to help you with this info.
I know I don't know anything (Socrates)
Dec 20 2022 10:03 PM
Could you please refer to the video .
Dec 21 2022 12:14 AM
Forgive me if I haven't answered by now, but despite the video and the file, I couldn't understand what your intention is. Describe please your plan step by step in more detail.
From which cell, which value, which sheet, where, etc. add photos if you think it is necessary.
At the same time, it would help if additional information could be provided, such as Excel version, operating system, storage medium, etc.
Please keep in mind that not everyone is familiar with electricity values, even if they have some basic knowledge :).
Thank you for your patience and understanding.