How to auto populate a table by entering a single value in one cell

[jayc2111]

I have a table containing various information including a version #. If I select a version # how do I get the table to auto populate based on its value. When I select 01 through 05 I would like everything below it blue to auto populate based on the information located on the tab Sheet1. See attached file.Burning Hot 7 - Configuration Sheet.xls

[Pete_UK]

Put this formula in B10:

=IF($B$9="","",IFERROR(INDEX(Sheet1!$B$7:$G$11,MATCH($B$9,GameVersion,0),MATCH(A10&"*",Sheet1!$B$6:$G$6,0)),""))

then copy down.

You will need to format the last two cells as a percentage with 2 dp, and note also that you have a space at the end of Max Bet in cell A11, which you will have to remove.

Hope this helps.

Pete

[Sam Capricci]

just use a bunch of vlookup formulas, see attached.

[Pete_UK]

@Sambo

you can use just one formula in B10:

=VLOOKUP($B$9,Sheet1!$A$7:$G$11,ROWS($1:2),FALSE)

and copy this down.

Hope this helps.

Pete

[Sam Capricci]

Pete, thanks, didn't even think of that way.

[jayc2111]

Thank you......worked perfectly!