hello i need help with an excel formula please.

[RICK150]

Hello

I work in logistics and a large part of my job is producing spreadsheets.

One spreadsheet i have to produce is given to me with the depot responsible for delivery set as a number. so depot 10 = newcastle and depot 12 = london.

When i input these i have to look through my list and find the depot name.

In column A i type the dopt numbers. Column B i've left blank for the formula. Way over in column G i have all the depot numbers listed and in column H i have the names of the depots that correspond to their number.

What i would ideally like to happen is when i type in the depot code in column a i'd like excel to automatically fill in column B with the corresponding Depot Name.

Anyone got any ideas they could tell me i'd be most appreciative.

Thank you in advance

Ricky

 

[Andrew Poulsom]

Welcome to the Board.

Check out the VLOOKUP function in Help.

 

[NBVC]

I think this is what you are looking for. Adjust range G1:H100 to suit.

=VLOOKUP(A1,G1:H100,2,FALSE)

 

[RICK150]

THANK YOU both very much i'm going to give that a try now.

Ricky