Help please fix my spread sheet!

[jonespandrew]

I have updated my spread sheet and for some strange reason my search page is not correctly displaying the info that i need.

Where is says it should search the sheet for example 5v sheet based on the led strip type that is selected and return the led colour with the biggest 100 power voltage and displat that voltage in the field next to it.

and it should also do the same based on the 50% power usage. But can't seem to get this to work.

Max Wattage@100%

Max Wattage @50%

Click on the link below and view update xls to see what it should do look at the other xls document,

Spread sheets

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Your link says "You need access".
In any case you will generally get faster/better responses if you provide some small representative dummy sample data (and the expected results) directly in your post because many helpers choose not to download files from other sites or due to security restrictions at workplaces, are unable to download such files.
MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in
(If you have trouble with XL2BB, review the "XL2BB Icons greyed out" link in the 'Known XL2BB issues' section near the top of the XL2BB Instructions page linked above.)

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.