Each cell has a code number, that code number brings up another code number in next cell

[nybeef]

Hello everyone,

I am attempting to build a mileage tracker based on a master list of code numbers. After submitting the date in cell A, in the next cell, B, I would type a code number from the list, say 7. Seven is the massage parlor that is 15 miles away. So 15 would come up in the next cell C. How can this be done? Thanks.

[Miroslav R.]

Hi there,
can be done with VLOOKUP:
Book1.xlsx

Hope it helps

[nybeef]

That works great. Big help! Thank you. How do I copy the code to reference the cell to the left for 1000 lines?

[Miroslav R.]

You are welcome!

Just fix the vlookup range with '$':

Please Login or Register  to view this content.

and drag down for as many lines as You want.

Does it help?