Hi I need a formula that can look through multiple tables and can pull out data when info is selected from drop down lists
I have tried VLookup and Index but have not been able to crack it.
File attached shows how many tables and what the drop down format looks like.
Any help would be appriecated
=OFFSET(A1,MATCH("Incidents "&A2,A9:A2000,0)+7+MATCH(B2,A10:A32,0);MATCH(C2,B9:M9,0),1,1)
Try this one
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
Tried it but formula doesnt do what i need.
Any other ideas?
Lets try In K first will be looking later for the other one if not yet been solved.
Formula:
Please Login or Register to view this content.
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
Fix them, the formula from popipipo is working bro..... you just forget the value in tables maybe?
Pls check the file
Azumi
Thank you to both VLADY and popipipo
Sorry Popipipo when i copied and pasted your formula in the desired box it keep on comming up with errors that were on my side, Formula works Brillantly. Thank you
PS Sorry for the late reply
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks