(Solved) – how to use vlookup in VBA micro,i want to vlookup for multiple same values in rows which has different values in multiple columns.?

(solved)-–-how-to-use-vlookup-in-vba-micro,i-want-to-vlookup-for-multiple-same-values-in-rows-which-has-different-values-in-multiple-columns.?

in example, we will take as below,

Name Time subject marks
Ragu 12 Maths 45
Ragu 05 Science 65
Jhon 12 English 80
Jhon 03 History 66
Banu 11 Civics 90
Banu 06 Geo 85

in the above table, i want the micro code as below, which i should extract in a new excel sheet.

If enter the name as, below i want have to lookup as follow,

Name Click
Ragu
Banu

Lookup – Answer in a new sheets, as all the values in coloumns and rows

Jhon 12 English 80
Jhon 03 History 66
Banu 11 Civics 90
Banu 06 Geo 85.

Please help us to complete it.

Leave a Reply

Your email address will not be published. Required fields are marked *