show data of reference cell instead of drop-don list

If you use conditional formatting you can highlight the contents of the equivalent in column M

It applies the filled range in column M

Please Login or Register  to view this content.

In column N place the following formula:

Please Login or Register  to view this content.

See attached sample

Originally Posted by adeel1

Hi Keebellah

i want result in same cell instead of column N, in drop-down list cell,can it possible..??

Adeel

In order to make your workbook little bit arranged and nicer, the list is created on a separate sheet and put your DV on sheet1.

See if this helps you

Best Regards
Imran Bhatti

You're welcome.

Originally Posted by adeel1

thnx imran bhai
this is good, no worry where is data pasted or arranged i need end result as my need which i got,,thnx

Adeel

You are welcome.

Dear imran bhai
one more thing, can it is possible that rather i select figure from drop-down list its works like some filter means i just write zahi, all zahi starts show in cell like filter search bar...??? i just mention in file zahi250,zahi500 so on, i have similar wp250, wp500 so on...
cell ect like filter search bar only & if someone write invlid value shows error..??pl
Adeel

I just saw your thread again by chance.You have asked another query within the solved thread.Forum requires that if your original question is fully answered .please start new thread for new query.