Forum Discussion
Look up value based on the voltage and frequency
Based on the frequency and voltage the values should be taken from the table.
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)
Could you please refer to the video .
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.
