LookUp

  • Thread starter Thread starter Roy
  • Start date Start date
R

Roy

Hi All,

Apologies if the below is confusing...

I have an excel application with which I need help.I have a workbook
with two sheets.On worksheet 1 ,on Col A (Roc),daily codes are
imported from an external source and the Col B(TIN) contains the local
codes which are derived from Col A using some formula.

I also have a query which downloads all the Roc codes from an Oracle
DB into col A of worksheet 2.
What I need to do is match the Roc codes in col A of worksheet 2 with
the Roc codes in Col A of Worksheet 1 and populate the Col B on
worksheet 2 with TIN codes of Col B in worksheet 1.

Finally I update the DB with the populated TIN codes on Col B of
worksheet 2.

Thanks,

Roy
 
Put the folllowing formula in column B in worksheet 2 (Cell B1 and
copy it to cells below for all rows which have corresponding data in
col A)

=VLOOKUP(A1,Sheet1!A$1:B$5,2,)

Change lookup array size as per your requirements

HTH
Regards,
Anirudh
 
Back
Top