Hi
I need to enter paddy variety in the column "Paddy Variety" under the Detail Bill sheet. I need to have multiple drop down lists(Around 5000) in column "Paddy Variety" with searchable option.
I have managed to set up a searchable drop down list in the first row WHICH WORKS FINE, but when I copy the drop down list to the next row. it is no longer searchable and I can only get a complete list of all paddy varieties in my drop down list. I have used the following formulas:
OFFSET
IFERROR(VLOOKUP(ROWS .....
IF(ISNUMBER(SEARCH ....... MAX
together with data validation to set up the searchable drop down list.
I need to do this with formulas without combo Boxes.
Could somebody please help on this
I need to enter paddy variety in the column "Paddy Variety" under the Detail Bill sheet. I need to have multiple drop down lists(Around 5000) in column "Paddy Variety" with searchable option.
I have managed to set up a searchable drop down list in the first row WHICH WORKS FINE, but when I copy the drop down list to the next row. it is no longer searchable and I can only get a complete list of all paddy varieties in my drop down list. I have used the following formulas:
OFFSET
IFERROR(VLOOKUP(ROWS .....
IF(ISNUMBER(SEARCH ....... MAX
together with data validation to set up the searchable drop down list.
I need to do this with formulas without combo Boxes.
Could somebody please help on this
Attachments
Last edited: