Ask Your Question

Big project need some tips

asked 2015-09-24 00:14:33 +0200

CronosWolfbane gravatar image

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.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2015-10-03 05:23:57 +0200

LKeithJordan gravatar image

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools



Asked: 2015-09-24 00:14:33 +0200

Seen: 51 times

Last updated: Oct 03 '15