Look up value based on the voltage and frequency

Iron Contributor

Based on the frequency and voltage the values should be taken from the table.

3 Replies

@ajmal pottekattil yoousuf 

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 .

@ajmal pottekattil yoousuf 

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.