Vlook up based off data validation

[jonespandrew]

Hi there

I have a spreadsheet that i want to create a separate info page for where based on the led strip type selection it will then display two pieces of information.

Box one will show the highest wattage vale you based on 100% power use of any of the colours RGB and white and then display the figure.
Then in another box do the same, but based on 50% power use for any of the RGB colours RGGB and white.

Then under each box it will then display a recommended power supply example 30w 12v 5 amps etc.

Can anyone help with this and i hope that i have explained it correctly.

Google drive

 

[NoSparks]

Can't get to your workbook.
Need to try sharing it again.

 

[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’)

I also suggest that you investigate XL2BB for providing sample data to make it easier for helpers. XL2BB will often also get you faster/more responses because many of the helpers here choose not to download files from other sites or, due to security restrictions at their workplace, are unable to download such files.