Want to retrieve data based on a matching condition from dynamic sheet reference.
say for eg
Sheet 1
======
Student Name | Subject | Marks
----------------------------------
Bill | English | ??
Bob |Maths | ??
Mak | Science |??
Bill (sheet2 name)
=============
Student Name | Section | Subject | Marks
-------------------------------------------
Bill | A | English | 90
Now let me know how can I use INDEX, MATCH & INDIRECT functions to retrieve value in column Marks in Sheet 1 C2.
Welcome to the forum, thank you for joining.
Moderator's Note: To other mod's. Have copy of this in the proper sub-forum. No need to move it. thanks.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks