Previous Topic Next Topic

Autopopulating new sheet based on an ans in 1 cell

Closed
NigelPearson Posts 1 Registration date Friday February 16, 2018 Status Member Last seen February 16, 2018 - Feb 16, 2018 at 11:44 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Feb 16, 2018 at 01:11 PM
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
Related:

1 response

Answer 1 / 1
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Feb 16, 2018 at 01:11 PM
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
0

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses