Hi,
Required a formula help for return a item lists as per drop down look up values as based on data in table (Column B to C).
Sample sheet attached.
Thanks for the help,
Hi,
Required a formula help for return a item lists as per drop down look up values as based on data in table (Column B to C).
Sample sheet attached.
Thanks for the help,
In G7 Cell - Array Formula - Requires CTRL+SHIFT+ENTER
Formula:Please Login or Register to view this content.
Drag the formula down.
Array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Please try at G7
=FILTER(C6:C17,B6:B17=E7)
data validation list = G7#
many thanks to all of you for your solutions,
here with required a another help for with 2 lookup criteria one is country second is months, only lookup country wise extract a values between the look up months.
Sample attached.
Please try
=FILTER(C6:C17,(B6:B17=E7)*ISNUMBER(SEARCH(TEXT(A6:A17,"mmm-yy"),E11)))
or
=FILTER(C6:C17,(B6:B17=E7)*ISNUMBER(SEARCH(TEXT(A6:A17,"[$-en]mmm-yy"),E11)))
Thank you so much bo_ry for your help and solution.
Thanks,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks