Re: $$Excel-Macros$$ How to distribute one value into different cells proportionately based on some conditions

Hi Try ths =VLOOKUP(E3,Sheet1!E3:G20,3,FALSE) On Wed, May 23, 2012 at 5:16 PM, Amit Gandhi silkyro...@gmail.com wrote: Hi Experts VLOOKUP is not working in attached file, can anyone help me why its not working and what will be right formula? Pls help me here. Regards Amit -- FORUM

Re: $$Excel-Macros$$ How to distribute one value into different cells proportionately based on some conditions

use this formula: =VLOOKUP(E3,Sheet1!E:G,3,0). On Thu, May 24, 2012 at 4:09 PM, vijayajith VA vijayajith...@gmail.com wrote: Hi Try ths =VLOOKUP(E3,Sheet1!E3:G20,3,FALSE) On Wed, May 23, 2012 at 5:16 PM, Amit Gandhi silkyro...@gmail.com wrote: Hi Experts VLOOKUP is not working in

Re: $$Excel-Macros$$ How to distribute one value into different cells proportionately based on some conditions

thanks On Thu, May 24, 2012 at 4:09 PM, vijayajith VA vijayajith...@gmail.comwrote: Hi Try ths =VLOOKUP(E3,Sheet1!E3:G20,3,FALSE) On Wed, May 23, 2012 at 5:16 PM, Amit Gandhi silkyro...@gmail.com wrote: Hi Experts VLOOKUP is not working in attached file, can anyone help me why its not

Re: $$Excel-Macros$$ How to distribute one value into different cells proportionately based on some conditions

thanks On Thu, May 24, 2012 at 5:50 PM, sreenivas kammari sreenivas...@gmail.comwrote: use this formula: =VLOOKUP(E3,Sheet1!E:G,3,0). On Thu, May 24, 2012 at 4:09 PM, vijayajith VA vijayajith...@gmail.com wrote: Hi Try ths =VLOOKUP(E3,Sheet1!E3:G20,3,FALSE) On Wed, May 23, 2012

Re: $$Excel-Macros$$ How to distribute one value into different cells proportionately based on some conditions

Thanks Mr. Haseeb Perfect solution. Thanks a lot. Amit On Tue, May 22, 2012 at 11:06 PM, Haseeb A haseeb.avarak...@gmail.comwrote: Hello Amit, Keep PO Bill Party Bill on different tab, so can easily update it. See the attached. Addition: If you use Table format, formula will

Re: $$Excel-Macros$$ How to distribute one value into different cells proportionately based on some conditions

Hi Experts VLOOKUP is not working in attached file, can anyone help me why its not working and what will be right formula? Pls help me here. Regards Amit -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like

Re: $$Excel-Macros$$ How to distribute one value into different cells proportionately based on some conditions

Hi Experts I am finding some problem in excel formula, pls help me here. I have a excel data at two locations, 1st is Supplier's Bill details and 2nd is Purchase order details. I need a formula that can distribute the Party Bill Amount figure proportionately to PO Amount figures based on B/L# .

Re: $$Excel-Macros$$ How to distribute one value into different cells proportionately based on some conditions

Pls Find Attached file On Tue, May 22, 2012 at 11:41 AM, Amit Gandhi silkyro...@gmail.com wrote: Hi Experts I am finding some problem in excel formula, pls help me here. I have a excel data at two locations, 1st is Supplier's Bill details and 2nd is Purchase order details. I need a

Re: $$Excel-Macros$$ How to distribute one value into different cells proportionately based on some conditions

Thanks Mr. Anil You have almost solved my query. But I need it more dynamic. You have made this formula cell specific and I need the formula which I can copy paste across all rows and it will give me result in one instant. Say for example, if I will add same B/L no again at row 21, i won't get

Re: $$Excel-Macros$$ How to distribute one value into different cells proportionately based on some conditions

Hello Amit, Keep PO Bill Party Bill on different tab, so can easily update it. See the attached. Addition: If you use Table format, formula will automatically insert, when you enter a new data. Or use dynamic range to limit calculation range. If you wish, you can also create a validation

$$Excel-Macros$$ How to distribute one value into different cells proportionately based on some conditions

Hi Experts I am finding some problem in excel formula, pls help me here. I have a excel data at two locations, 1st is Supplier's Bill details and 2nd is Purchase order details. I need a formula that can distribute the Party Bill Amount figure proportionately to PO Amount figures based on B/L# .