grabbing error values

[syed_iqbal]

Hi,

I need vlookup formula in vba to apply across multiple sheets (lookup on "Student Name" itself in every sheet except "Master Sheet"). if there are any errors come then Actual student names (from master sheet) and mismatched values (from across multiple sheets) & sheet names where error occured (respective sheet name should return against each unmatched value)should return in new sheet (sheet name:="unmatched values"). After getting all unmatched values then all newly added columns (for vlookup) should delete automatically.

Pls go through the sample attachment. I created sample "unmatched values" sheet.

Note: Student names mentioned in random columns in multiple sheets.


thank you very much in advance

[syed_iqbal]

I tried myself and got the solution. thanks to all who tried to help me.