Populating multiple cells with drop down

brando6003 · Apr 19th 2017

I'm trying to populate the data from 'rate schedules' onto 'main' once an item from the drop down list is selected but can't seem to find a function that works. Any advice?

**NBVC** · Apr 19th 2017

Re: Populating multiple cells with drop down

You can use Index/Match.

e.g. to get the Mid Winter rate:

[COLOR="#0000FF"]=INDEX([COLOR="#FF0000"]tbl_items[Winter Mid][/COLOR],MATCH(B1,tbl_items[itemnum],0))[/COLOR]

you would just need to change the [COLOR="#FF0000"]Red [/COLOR]reference to point to relative column you need results from.

Populating multiple cells with drop down

Participate now!

Share

Users Viewing This Thread