Formula to Display Cells from Another Page Upon Selection

I'm trying to create a formula that displays certain cells when a a selection is made from a drop-down list in another cell. Here's what I have:

=IF(C2="General",'Data Validation'!M3:P6,FALSE)

C2 is where the drop-down list is and if they select General I want it to pull and display the cells M3:P6 from the sheet Data Validation.

I keep getting a #VALUE! error.

Any thoughts on this? Or is there a different way to go about this? My hope is to eventually be able to select any of the drop-down options (there are 5) and all be able to display something different when they are selected.


Thanks for the help!

The reason for the error is that you are trying to display an array in a cell. Is it a table? you may use the Vlookup() or Match() functions to retrieve the desired data depending on the chosen value of c2. If unclear, send a sample...

It's not a table. It's just a Name in one column and an IP address in the column next to it. 5 rows of names and columns. If I do a VLOOKUP, how do I get it to display all the information I selected?

Please Login or Register  to view this content.

the function should be inserted in the desired cell

d1 would be the cell that you looking for
a1:b5 the range containing the names in column a, the ip in column b
false forces the function to return an exact match (if there is no match it would return N/A)