look up problem

[VBABEGINER]

Hi All,

I was trying this by v look up but not getting.
I have 2 differnet excel sheets.

Sheet1 - col E contain some ID tags.

Sheet2 - Col A to Col E contain the information of all students.
col A - ID no ..... this id no same as Col E contain in sheet1.
col B - Desc of stud
Col C - Status
Col D - Data
Col D - Data

I made one more col besides Col E of sheet1. = F Column

In F col, say cell F8, i was trying to use v look up to get this information.

This "Col C - Status" i require in sheet1 in Col F.

Is it possible?

Problem is - sheet1 contains all id's in single column only. i.e- in col E.

But, Sheet 2 having multiple sheets and therefore, it contains -
col A - ID no ..... this id no same as Col E contain in sheet1.
col B - Desc of stud
Col C - Status
Col D - Data
Col D - Data

This data to every sheet.

Now is this possible to get the data from multiple sheets to one sheet?

Dear All,
Please require your kind Solution?

 

[VBABEGINER]

Anyone?

 

[Joneye]

Can you post any data.