Hi Please see attached file
I am having trouble getting index match formula correct when i'm trying to reference dates and also when looking up values not found in source table
please advise correct formula and what ent wrong in my approach
Hi, I have attached file. I'm trying to look up values from "Sourcr tab" referencing to columns A and B ad the result to be produced in "result tab"
What makes it complicated is there are lot of duplication in column A
Kindly assist with formula
I am basic learner in charting. I have a file which involves multiple (more than 2) variables I would like to compare using charts
Could you kindly suggest the best possible way to do this ? Thanks
HI Ramesh, Sorry after going through the file in detail, There seems to be some issue with the formula. COuld you please check, as I marked the error in red and given desired answers next to it. Could you please check
Thanks Hui and Khalid. Both formula worked. By helper columns I meant, we modify existing data to separate what we are exactly looking for , example in T1-L1-0115, we are looking for 0115, so we create another column which shows 0115 and then do a vlookup sort of search. But both formulas worked...
Hi Dear Friends
I have the below items on which i need to do a lookup to get corresponsing values from the lookup data
Look UP data is
Thanks Nebu. Pivot table would do the trick and would serve the purpose. I was looking in to more of a formula. Should do the job for now. Thanks heaps. Can you also please suggest a summing formula based on what i have mentioned in the "sheet 1" tab