Edit Formula to Auto-Populate Down Table

[akvpv6]

Good Morning,

I am looking for help on editing the formula seen in the first attached image. The formula itself is working, however, I am trying to edit it so that the formula auto-populates down the entire table. As of right now the only way to get the formula into the cells below is by highlighting the cell with the formula and dragging it downwards.

The formula itself is set up so that when I select someone's name in column B the corresponding business unit in column A auto-populates.

Thank you!

Andrew

 

[Fluff]

Remove the $ signs from B2 & put them on the lookup range.

 

[akvpv6]

Remove the $ signs from B2 & put them on the lookup range.

Do you mean like this:

=VLOOKUP(B2,Sheet5!$A$2:$B$29,2,FALSE)

 

[Fluff]

That's right.

 

[akvpv6]

That's right.

Thank you that seemed to work!

 

[Fluff]

You're welcome & thanks for the feedback.