![]() |
#9
|
|||
|
|||
![]()
Here is an example what I thought in my yesterday's post.
Enter data from all your 3 normal power tables into table on NormalPower sheet (i filled it only enough to use your example data) - for all frequencies from A through D. On sheet EBI200, edit the value returned when data were out of range, i.e. the formula returns 0. Currently the empty string is returned when this is the case. |
Tags |
index and match, lookup, vlookup |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Mechaman | Excel | 2 | 04-11-2021 02:54 AM |
Excel thinks I am creating a formulae | TimTDP | Excel | 2 | 07-28-2020 12:30 PM |
What's wrong with formulae? | kingston123 | Excel | 5 | 06-29-2020 10:55 AM |
help with formulae | Zoemoe | Excel | 3 | 07-02-2017 05:40 PM |
![]() |
Friedebarth | Word | 1 | 11-30-2011 02:22 PM |