[mso] Re: Excel - If Then
- From: PrIyAnKa <p.dhamsaiya@xxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Wed, 12 May 2010 11:30:50 +0530
not getting excatly what your problem is
if i get you i can help you so can you make me understand in some easy way
Regards
Priyanka
On Tue, May 11, 2010 at 11:46 PM, <cjb4622@xxxxxxx> wrote:
> Hello group, I hope everyone is doing well. Thanks for your help last week,
> it was greatly appreciated. I have a question regarding "If,then" statements
> in excel (or maybe v-lookup?). The problem is as follows -
>
> 1. I am working off of two tabs (worksheets) in excel.
>
> 2. Tab 1 - In cell A58 I have the description ?Fuel?? in cell F58 I have
> assigned the number 4
>
> 3. Tab 2 ? Column N lists various descriptions per cell (fuel or
> maintenance or handling or etc) ranging from N298:N12456? Based on the
> description ?Fuel? in cell A58, TAB1, and the assigned number ?4? in cell
> F58, TAB1... I am wondering if there is a formula that can pick out all
> cells with the description ?Fuel? in column N, and provide all cells with
> description ?Fuel? with the assigned number 4 in column M? I could then copy
> this formula for my other attributes.
>
> Not sure if this possible, but thank you for your help once again.
> Regards,
> Chris
>
>
>
>
>
>
>
> -----Original Message-----
> From: cjb4622@xxxxxxx
> To: mso@xxxxxxxxxxxxx
> Sent: Thu, May 6, 2010 5:55 pm
> Subject: [mso] Excel - If Then
>
>
> Hello all,
>
> am currently working on an excel file and have a question. Here it goes...
>
> . I am working off of two "tabs" (worksheets) in excel.
>
> . The first tab I will label "A". In tab A, I am working with three columns
> of
> ata. In column D, I have various titles listed. The range is from
> D189:D1264.
> f one of the titles listed in column D is "CAR", I am placing a "1" in
> Coulmn
> , next to car. So D189 is car, so I input 1 in E189. If it says "Bus", I
> will
> nput a 2, and if it says "Plane", I will input 3. Finally, in column N189,
> I
> ave a balance of $10 for the car.
>
> . On tab B, I have 2 cloumns of data. Column A has three titles listed in
> 8,A9,and A10. They are Car, Bus, and Plane. In column B, cells B8, B9, and
> B10,
> would like to sum the total balances for all cars, buses, and planes I
> coded
> , 2, and 3 on Tab A. So B8 would sum all "1"'s from Tab A, B9 would sum
> all
> 2"'s from Tab A, and B10 would sum "3"s from Tab A.
> Thanks for all your help in creating this "If,then" statement.
> hris
>
>
> *************************************************************
> ou are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
> icrosoftOffice@xxxxxxxxxxxxxxxx
> To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
> To Unsubscribe from this group, visit the group's homepage and use the
> dropdown
> enu at the top. This will allow you to unsubscribe your email address or
> hange your email settings to digest or vacation (no mail).
> ttp://www.freelists.org/webpage/mso
> To be able to share files with the group, you must join our Yahoo sister
> group.
> his group will not allow for posting of emails, but will allow you to join
> and
> hare problem files, templates, etc.:
> http://tech.groups.yahoo.com/group/MicrosoftOffice
> This group is for FILE SHARING ONLY.
> If you are using Outlook and you see a lot of unnecessary code in your
> email
> essages, read these instructions that explain why and how to fix it:
> ttp://personal-computer-tutor.com/abc3/v28/greg28.htm
> ************************************************************
>
>
> *************************************************************
> You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
> MicrosoftOffice@xxxxxxxxxxxxxxxx
>
> To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>
> To Unsubscribe from this group, visit the group's homepage and use the
> dropdown menu at the top. This will allow you to unsubscribe your email
> address or change your email settings to digest or vacation (no mail).
> //www.freelists.org/webpage/mso
>
> To be able to share files with the group, you must join our Yahoo sister
> group. This group will not allow for posting of emails, but will allow you
> to join and share problem files, templates, etc.:
> http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for
> FILE SHARING ONLY.
>
> If you are using Outlook and you see a lot of unnecessary code in your
> email messages, read these instructions that explain why and how to fix it:
> http://personal-computer-tutor.com/abc3/v28/greg28.htm
> *************************************************************
>
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, visit the group's homepage and use the dropdown
menu at the top. This will allow you to unsubscribe your email address or
change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to share files with the group, you must join our Yahoo sister group.
This group will not allow for posting of emails, but will allow you to join
and share problem files, templates, etc.:
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE
SHARING ONLY.
If you are using Outlook and you see a lot of unnecessary code in your email
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
Other related posts:
