References between cells

  • Thread starter Thread starter yohann
  • Start date Start date
Y

yohann

Hello i am french ill try to be clear.
I'd like to have 3 names like "X","XY" and "XZ" that would be interpreted by
Excel like X family
In other word if cell A1=X and cell [email protected]
if cell A2=XY and cell [email protected]
if cell A3=XZ and cell [email protected]

Then if the user type in XY in cell A4 then the email loaded will be
(e-mail address removed) .Id like to be able to generalize this principle and to have the
ability to decide that x,xy,xs,xd,xe will refer to (e-mail address removed) for example
and create a kind of reference table
Thank you for your help
 
This can be done with INDEX and MATCH, (or VLOOKUP) I think.

From your question, I read that if the first letter of X, XY, XZ,
XASDASLKJHD would still be in X family?

In some other area, create your reference table, such as in Sheet2 the range
A1:B2
A1: X
A2:Y
B1: (e-mail address removed)
B2: (e-mail address removed)

now, next to the cell where the user enters XY, or YZ, etc. use:

=INDEX(Sheet2!B$1:B$2,MATCH(LEFT(A1,1),Sheet2!A$1:A$2,0))
 
here is what I came up with if I understand you correctly it will wor
for you.

in cell B4 enter:

=IF(FIND("x",A4)=1,B1)

when some puts anything in A4 this function checks to see if x is th
first letter and then gives the email in the cell b1, I choose B1 a
randomn
 
Back
Top