Hi,

I am new to this forum... so I donno if I have posted my message at the right place.... or not ..... I have worked with excel but I have not worked with the various complex calculations that it can do. Please help me .... my requirement is as follows...


I have 3 sheets ... Sheet 1 :- Where in I have the actual data downloaded from some other system. Sheet 2:- The calculation sheet where I have to display the result after doing some manupilation to the actual data in sheet 1.... Sheet 3:- the match code sheet...

Below is an example of the Sheet 1 i.e. Actual Data...
SD | 8610 | 17132 | 09656 | 000 | 000 | 0000

Now my problem is that I have to search distinct values of column 1, column 2 & column 3... Then I should go to the match code sheet (i.e. sheet 3) where the value of column 2nd i.e. 8610 is given ... I have to pick up this value .... then concatenate column 1 + match code value of column 2 + "F0" + column 3..... the value thus achieved needs to be displayed in sheet 2....

Below is an example of the Sheet 3 i.e. Match Code sheet
Abr | Function Code | Function description
E | 8610 | Selling Expense 8610

So for the above example the value that I want to display in Sheet 2 is :- SDEF017132....

Can anyone help me.... I will be very grateful & Thanx in advance...

-Capri.