Enter value in sheet 1 returns a value from sheet 2 ?

[Waldemar]

I'm trying to figure out a formula string to get data in a worksheet based on search in a reference table in another worksheet.

I've got a tab 'ref' , with a reference table like

/ref\
---- [A]
[1] 101 AAA
[2] 102 BBB
[3] 103 CCC
etc.

I've got a second tab with for instance 'issues' and I want to enter an ID in column A to get the related description from the reference table in column B; like

/issues\
---- [A] -----
[1] 101 --> AAA
[2] 103 --> CCC
[3] 101 --> AAA
etc

The issues list will grow but also the reference table will change from time to time.

Thanx in advance!
Waldemar

 

[rs2k]

Welcome to the board,
Use VLOOKUP.
If you don't know how it is done, try a search on this board or post back.

Colin.