Hi,
In my added example I have a red table with an item code, warehouse code and a warehouse location code.
In the blue table I have two lookup lists with unique warehouses and warehouse locations, that I retrieved from an SQL database.
I would need a dependent data validation for the grey cells in column G, so that in G3 I can only choose from [001] and [002], since they belong to warehouse 1.
How would I do that ?
Thanks for helping me out here..
Example dependent dropdown.xlsx
In data validation use Allow -- List and in 'source' use
=OFFSET(INDEX($C$3:$C$9,MATCH(F3,$B$3:$B$9,0)),0,0,COUNTIF($B$3:$B$9,F3))
Also ensure that your Warehouse numbers in Column B are numbers and not text
Life's a spreadsheet, Excel!
Say thanks, Click *
Thanks for your answer...
I have been trying for about an hour now, but I cannot get it to work.
I have tried it in data validation, but I get the message it results in an error (2042)
The same goes for pasting the formula in a normal cell.
I also resetted all of the cell formatting to 'Standard',
The thing is that I do not get the syntax behind the formula that you have sent me, so troubleshooting is somewhat difficult.
Do you have any idea what could be wrong?
Hi,
Just to finish this thread...
I have started on a new sheet and now everything seems to work fine.
Probably some left over text formatting that got in my way...
Thanks again for helping me out...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks