Lookup
Hi all Could anyone tell me How can i lookup data based on text. I have given an example below where i have various vehicles with there code and i want to be able to segregate them in respective feilds based on their headings which is common. e.g Fuel, Fine.....
e.g
Fuel 15B67 £20
Fuel 25A68 £45
Fine 5y376 £20
Thanks... !!
Last edited by tek9step; 06-03-2009 at 06:52 AM.
I must say Pivot Table is the best thing to do this type of work ......
If this post helps, Please don't 4get to click the star icon located at the bottom left of my Post.
PivotTable is the best global answer, especially if you're building a full chart of all categories anyway, you get the work done all at once.
If you only want a couple of answers, then perhaps a SUMIF() will suffice:
=SUMIF(A:A,"Fuel",C:C)
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks