excel question

[zoukou55]

I have 6 items in my drop list and with their own budget

When I chose an item, it is possible that his budget appears in the appropriate cell

for example, when I chose "vehicle maitenance", I want to see automatically his budget, his cost centre, and total cost


thanks

 

[Faseeh]

Hi zoukou55,


Welcome to the Chandoo's forums!!


You can do that with either vlookup() or index() & Match(). Depdnding on how data is present these will work:

=vlookup("Vehicale Maintenance,YourTable, ColumnUWantToLookInto)


OR


=Index(ColumnUWantToLookInt,Match("Vehicale Maintenance",HeaderRow,0),0)

...It would be help full if you upload a sample file in case this doesn't work.


Regards,

Faseeh

 

[zoukou55]

ok thanks

will try and let u know

 

[webellr]

Thanks, I was also looking for this

POS software

 

[webellr]

thanks , I was also looking for this