CODEWITHSUNDEEP
excelexcel-formulaexport-to-excel
Marketio Management
Marketio Management

Reputation: 1

Which Formula can i use for to auto fill my table if i predefine it

if party name match with my predefine list on the right side it select automaticity manager name and zone of the party name in the left side. image is attached. please help enter image description here

Upvotes: 0

Views: 35

Answers (1)

antca230
antca230

Reputation: 56

In cell B2: =VLOOKUP(A2;$F$2:$H$100;2)

In cell C2: =VLOOKUP(A2;$F$2:$H$100;3)

P.S H100 can be changed depending on your table size

Upvotes: 1

Related Questions