DEAR SIR/MAM:

I AM FACING A PROBLEM IN WORK SHEET. FOLLOWING IS THE EXAMPLE

(A) (B)
Al Masaood C541917999
Tamimi C52191A999
Jamil Bustami C515932999

THERE ARE THREE NAME IN "A" AND EACH NAME HAS ITS OWN CODE AS MENTION IN "B"

MY NEED IS TO GET AUTOMATICALLY THE CODE IN COLUMN B IF I AM TYPING
ANY OF THIS NAME IN COLUMN A

FOR E.G. IF I M TYPING " AL MASAOOD " IN COLUMN A

THAN THE VALUE IN COLUMN B SHOULD AUTOMATICALLY REFLECT "C541917999"

OR VISA VERSA

KINDLY HELP ME BY SOLVING MY PROBLEM ASAP.

THANK YOU IN ANTICIPATION FOR YOUR SUPPORT.

KIND REGARDS

BHARGAV PANCHAL

Hi,

Put this formula in a cell (say) F1

=IF(E1="","",VLOOKUP(E1,A1:B3,2,FALSE))

Now type your name in e1.

Mike

"BRIDGESTONE" wrote:

DEAR SIR/MAM:

I AM FACING A PROBLEM IN WORK SHEET. FOLLOWING IS THE EXAMPLE

(A) (B)
Al Masaood C541917999
Tamimi C52191A999
Jamil Bustami C515932999

THERE ARE THREE NAME IN "A" AND EACH NAME HAS ITS OWN CODE AS MENTION IN "B"

MY NEED IS TO GET AUTOMATICALLY THE CODE IN COLUMN B IF I AM TYPING
ANY OF THIS NAME IN COLUMN A

FOR E.G. IF I M TYPING " AL MASAOOD " IN COLUMN A

THAN THE VALUE IN COLUMN B SHOULD AUTOMATICALLY REFLECT "C541917999"

OR VISA VERSA

KINDLY HELP ME BY SOLVING MY PROBLEM ASAP.

THANK YOU IN ANTICIPATION FOR YOUR SUPPORT.

KIND REGARDS

BHARGAV PANCHAL