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
-
Posts
1942
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 2, 2021
-
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
1942
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 2, 2021
145
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