Excel Form Help

[uvicky125]

Hi All..It's my first query in this forum...

I have a repeated database with details of 5000 property... I create file with all the fatures like vlookup, count, find, etc etc.. now I need to create a form in which I can enter the property no, date, amount and few other details to specific columns... and other forumula's will based on that fields... I couldn't find anywhere how I can create a form with specific column entry.. is any one can help

cheers

 

[Hui]

Uvicky125

Firstly, Welcome to the Chandoo.org Forum

Can you please post a sample file and highlight what fields you want to retrieve

It sounds like a solution will be based on an Index/Match formula to retrieve the various fields as required

You may want to have a read of:
http://chandoo.org/wp/2008/11/19/vlookup-match-and-offset-explained-in-plain-english-spreadcheats/
&
http://chandoo.org/wp/2013/09/18/index-formula-usage-and-tips/

 

[uvicky125]

hi there... file is attached

Uvicky125

Firstly, Welcome to the Chandoo.org Forum

Can you please post a sample file and highlight what fields you want to retrieve

It sounds like a solution will be based on an Index/Match formula to retrieve the various fields as required

You may want to have a read of:
http://chandoo.org/wp/2008/11/19/vlookup-match-and-offset-explained-in-plain-english-spreadcheats/
&
http://chandoo.org/wp/2013/09/18/index-formula-usage-and-tips/

 

[Nebu]

Hi:

Find the attached.

Thanks