hi all,

i have a problem returning a value from another cell.

in sheet 1, i have:
column A 'ID' : 1, 2, 3, 4, 5
column B 'S' : a, b, c, d, e
column C 'C' : A, B, C, D, E
this is the basis for the other page, it should be possible to return these
different values into the other page.

in sheet 2 i have:
column A : 1, 3, 1, 5, 4, ... (the same ID values as in sheet 1)
column B : S or C ("S" refers to column B in sheet 1, "C" refers to column C
in sheet 1), i.e. ID can be either "S" or "C".

column C : here's my problem.

i want to add a formula that returns the value from either column B or C
from sheet 1 that corresponds with the value in column A of sheet 2.

example:
SHEET 2:
A2 = 3
B2 = S
than the value in C2 should be 'c'.

on the otherhand, if:
SHEET 2:
A2 = 3
B2 = C
than the value in C2 should be 'C'.

i managed to solve the problem via vlookup, but the thing is that if
somebody inserts a column in sheet 1, the formula doesn't work anymore.
is there a 'safer' possibility that copes with this (e.g. by naming column B
and C in sheet 1 or something)?

thanks for the help !
andy