Big project need some tips

[CronosWolfbane]

I am creating a sheet that when you change the drop-down option in A1 it will change the data presented in different cells on Sheet1. What would be easier is if I could change the drop-down value and it would pull the information from somewhere else and auto fill the required cells. The only thing I could think to do was use IF statements in all the cells that need to update based on A1. In an attempt to shorten some of my work I was trying to write an “IF” statement that would change other cells with info but that did not work. The drop-down is going to have over 600 different options meaning the below formula x600 “IF’s”

=IF(A1=“name”,B4=5 B5=5 B6=5 B7=7 B8=7 B9=5,IF(A1=“name”,B4=6 B5=6 B6=6 B7=8 B8=8 B9=6, )) ect

Any advice or tips would be appreciated I also have next to no skill with the macros.

[LKeithJordan]

Your description is not entirely clear and you did not provide an example, but it appears you need to use the VLOOKUP function. Here is how it works:

You have a list of options in spreadsheet 1 cell A1, perhaps derived from a data table in spreadsheet 2. You have the information to be required in spreadsheet 3, perhaps included in a named range. You include the VLOOKUP function in a formula for every cell to display the changed results.

The VLOOKUP function looks in the range for the criteria specified in spreadsheet 1 cell A1 and returns data from the column you specify when it finds the first match.