I have a similar problem, can someone please help!!

I have two lists in a row and I would like them to be dependant on each
other. For example "list 1" - A1=dave, A2=colin, A3=trevor, A4=daniel, "list
2" - B1=18, B2=22, B3=55, B4=24,

I need my spreadsheet to link these two lists so that if somebody drops down
"list 1" and chooses 'colin' (from A2) the next cell will automatically
display '22' (from B2).

I hope i have explained this correctly. Any help would be much appreciated.

Thanks

Daniel


"Pete_UK" wrote:

You're welcome - thanks for feeding back.

Pete

On May 19, 4:41 pm, Wackyracer
wrote:
Thanks very much. Exactly what I needed.