Search results

then how is this file function index and match working with indirect function i want the same of it. https://hotfile.com/dl/182138390/43f7dfd/1234.xlsx.html

https://hotfile.com/dl/182132207/3d018c3/rahulsss_(1).xlsx.html this excel file has formula in cell b28 and and data validation is their in cell a27 and a28,so whenever user changes a27 and a28 the corresponding values should change in cells b28:g28. so formula is already their in b28 but...

sorry here is the link i am sending you as attachment in which the formula is in cell B28 https://hotfile.com/dl/182130348/0f135ce/rahulsss.xlsx.html

Hi Bob, the formula is in cell b28 of the excel file as attachment.

I am attaching an excel file as my query. In the file in cell b28 i am applying index match formula but its not working showing ref# error.Some minor mistake is their but i am not able to figure it out. Kindly fix the error with the same index match formula.Plz reply and send the file on...

Hi, I just need one simple example of dashboard creation in excel 2007 showing formulas. I am new to dashboard ,all i want is a simple dashboard example with different charts relating to the raw data. just a simple example of dashboard,those given as you suggested are of high types. So...

Hi, Can anyone give me a step by step creating dashboard in excel 2007 showing formulas. Thanks Rahul

Dear Narayan, Thanx a lot brother i got it. rahul

hi narayan, i am unable to figure out how you gave named range to data_range.I think for each sheet their will be a different name of data_range. how you did it brother. plz clarify. thanks, Rahul

hi narayan & kaushik, thanx a lot for your continuing replies. the only thing in my mind is that what data_range denotes in the formula exactly.is data_range is also a named range. can i use $a$1:$c$4 in place of data_range. thanks, Rahul

narayan, plz send the link to hotfile because i am in office and their is proxy security,so i cant have access to all sites.so plz send the hotfile.com link. thanks, rahul

Hi Kushik, here is the link to my excel file. thanks, rahul https://hotfile.com/dl/180367232/660f0e4/rahul.xlsx.html

brother i am executing it with ctrl+shift+enter but i dont know its still not working.i cannot find any way to send as attachment the excel file so that it will give you the exact scenario.if you have any mail id please tell me so that i can send you the excel file. thanks, Rahul

Hi Narayan and kaushik, the formula given by you,i pasted it exactly but its not working.Their is no error with the list of sheets and data range names.i had changed them accordingly but its still not working and showing not found for all the values.

The idea being that if VLOOKUP doesn't find a match on the first sheet, it will check the next sheet and so on. like if in sheet1 we have product code aand price columns with 100 product codes given. next we have 10 sheets from sheet2 to sheet11 with product code aand price columns duly...