K koskesh Member Nov 7, 2014 #1 Hi, I need to do a lookup from a pivot table and used index and match to do that. It works but not for all values. I dont know how to explain the issue. I just upload the file Thanks Attachments verweis3.xlsx 18.9 KB · Views: 12
Hi, I need to do a lookup from a pivot table and used index and match to do that. It works but not for all values. I dont know how to explain the issue. I just upload the file Thanks
Hui Excel Ninja Staff member Nov 7, 2014 #2 Koskesh The date values in G3:J3 are text not dates Retype them as Dates eg: 19/3/2014 etc and everything else is ok
Koskesh The date values in G3:J3 are text not dates Retype them as Dates eg: 19/3/2014 etc and everything else is ok
Faseeh Excel Ninja Nov 7, 2014 #3 I think you can simply rearrange data to get the desired results. Attachments verweis3.xlsx 21.4 KB · Views: 6
