[SOLVED] Lookup based on Column headers

[rkb2k9]

Hi,
I am looking for a VBA code to do lookup if the Column header matches on two different sheets and the result has to be displayed next to the last cell.

For ex:-

Sheet1 is having 12 columns out of that a column having header desc

sheet2 having 10 columns out of that a column is having header desc

now i have to lookup sheet1 desc column value in sheet2 desc column values and result has to be shown next to the last column

Thanks for help in advance
Regards,
Rkb2k9