Dear Sir,
Pls find enclosed in attachment.I have done for two data taking some specific data list only of corresponding matches and not the entire as I do not know how to do.All this I want to be taken in taking entire range of data range.
With Best Rgds,
Suresh
I don't know if this does what you want. Let us know.Originally Posted by paradise2sr
Dear Sir,
Thanks for the reply.
In F3,you have linked the formula with G3.How that is possible ? Becoz G3 is dependent on F3.
Let me explain entire scenario again.After that,kindly try to achieve the desired result.
When I select 2784 which is in E3.Now in F3 it should display list in dropdown---- Apple
in G3 it should display list in dropdown
Xzone Salt
Y Agarbatti
Zone Sail
XA
X2
When I select 3245 which is in E4.
Now in F3 it should display list in dropdown
Orange
Pomegrante
in G3 it should display list in dropdown (If in F3 Orange is selected)
Everest Agrabatti
Wheel lemon Surf
or,
in G3 it should display list in dropdown (If in F3 Pomegrante is selected)
Shake well Soap
Hope now this has been transparent now.This is only a sample data.
With Best Rgds,
Suresh
Last edited by paradise2sr; 12-15-2014 at 06:01 AM.
Not sure I have the concept yet, but please try this one.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks