Autopopulating new sheet based on an ans in 1 cell [Closed]

Report
Posts
1
Registration date
Friday February 16, 2018
Status
Member
Last seen
February 16, 2018
-
Mazzaropi
Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
-
Hi,

Hoping you can help. I need a solution whereby if I select a certain value from a drop down list it will autopopulate that row of data in a separate sheet. In essence I want to create a list of companies who are talking to us about a specific product, where this is identified in the first sheet.


Thanks in advance for any help you can provide.

Regards


Nigel

1 reply

Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
135
NigelPearson, Good afternoon.

You can use a VLOOKUP function, or a combination of INDEX + MATCH functions or a LOOKUP function or others.

BUT...It's necessary to know your exact layout to help you effectively..

I hope it helps.
- -
Belo Horizonte, MG - Brasil.
Marcílio Lobão