Auto populate cells based on other cells from a lookup range

[MaxMurphy13]

Good afternoon. I am trying to auto populate a cell based on another cell. So depending on what I input for revenue in A2, the Range(B2) and Rate(C2) will auto populate using the lookup data.

Any ideas?

Thanks much.

​

 

[mackc557]

It would be much easier to do this if Range Lookup was in two separate columns, one for the low end and one for the high end. Does Range Lookup need to be in a single column? It can be done both ways, but two columns is much easier.

 

[MaxMurphy13]

It would be much easier to do this if Range Lookup was in two separate columns, one for the low end and one for the high end. Does Range Lookup need to be in a single column? It can be done both ways, but two columns is much easier.

Yes, that did it using vlookup. Thanks so much!