Microsoft Excel - vlookup?

Asked By Tammy
09-Feb-12 07:24 PM
Hi, I am trying to do the following with this data:

Name  ProductA  ProductB  ProductC
Will    RE        FE        EE
Naomi  RE                   EE
Charles            FE


I now need to display who teaches which product. So I need it to display this way:
RE  Wil   Naomi
FE   Wil   Charles
EE   Wil    Naomi

Thanks for any help!
  Donald Ross replied to Tammy
10-Feb-12 12:15 AM
Tammy  this looks alot like your post about milk bread and eggs

http://www.eggheadcafe.com/community/excel/66/10419705/lookup.aspx

From that post.

"I don't know about lookup but to achieve the output you can consume excel IF and Concatenate function.

Say if you Name(A1),Egg(B1),Bread(C1)and Milk(D1) you can use the formula
=CONCATENATE(A2,IF(B2="Y",$B$1,""),IF(C2="Y",$C$1,""),IF(D2="Y",$D$1,""))

Name Egg Bread Milk
John Y N Y JohnEggMilk
Bill Y Y Y BillEggBreadMilk
Jane Y Y N JaneEggBread

_______________________________________________

So if you now need Product A, then B, the C, then Name
=CONCATENATE(IF(B2>"",$B$2,""),IF(C2>="",$C$2,""),IF(D2>"",$D$2,""),A2)
I moved Colum A to the end and use > to simply show for a value.
your data would be in the second row.

HTH Don

  Donald Ross replied to Tammy
10-Feb-12 12:16 AM
Tammy  this looks alot like your post about milk bread and eggs

http://www.eggheadcafe.com/community/excel/66/10419705/lookup.aspx

From that post.

"I don't know about lookup but to achieve the output you can consume excel IF and Concatenate function.

Say if you Name(A1),Egg(B1),Bread(C1)and Milk(D1) you can use the formula
=CONCATENATE(A2,IF(B2="Y",$B$1,""),IF(C2="Y",$C$1,""),IF(D2="Y",$D$1,""))

Name Egg Bread Milk
John Y N Y JohnEggMilk
Bill Y Y Y BillEggBreadMilk
Jane Y Y N JaneEggBread

_______________________________________________

So if you now need Product A, then B, the C, then Name
=CONCATENATE(IF(B2>"",$B$2,""),IF(C2>="",$C$2,""),IF(D2>"",$D$2,""),A2)
I moved Colum A to the end and use > to simply show for a value.
your data would be in the second row.

HTH Don

Create New Account
help
concatenate Excel = Concatenate(", A2, "", C2, "", E2, ") a2 c2 e2 f2 2378 7011 011 = Concatenate(", A2, "", C2, "", E2, ") I am trying to tie together fields that are formatted as general. I am using the above concatenate formula but keep just seeing the actual formula and not the numbers that I want to see. What am I forgetting or putting in wrong??? Thanks, Barb Excel Miscellaneous Discussions Microsoft Word (1) Excel 2003 (1) Autocalculate (1) Forumula (1) Babs (1) = Concatenate(A2, "", C2, "", E2) or more simply
what is the "&" used for in excel Excel Excel Miscellaneous Discussions Microsoft Excel (1) Grahamit (1) February (1) Conatins (1) Month (1) Hi Graham it is used to concatenate text or multiple cells. e.g. A1&B1, will combine the information from the two the month of February" Where B1 conatins a number like 123, 456 Gord Dibben MS Excel MVP keywords: what, is, the, "&", used, for, in, excel
Hard return in concatenate Excel How do I enter a hard return between two fields I concatenate? Excel Worksheet Discussions Microsoft Excel (1) Excel 2003 (1) CHAR (1) AppleOrange (1) Vbnewline (1) Alt (1) Wraptext (1) Pamp (1) Like cell) But I get: AppleOrange Char(10) didn't work for me. I am using Excel 2003 - - R. Khoshravan Please click "Yes" if it is helpful. Hi, You will have to
CONCATENATE Excel Using excel 2007 If I concatenate excel cells that have a format of two digits like 117.00 - - 114.36 - - 89.60 show 2 decimal placings Will I need to write a function to do this? Cheers. Excel Worksheet Discussions Microsoft Excel (1) CONCATENATE (1) TEXT (1) Devenshire (1) Shane (1) Placings (1) Bliengme (1) Caps (1
Select and Print only Text Excel Microsoft Excel 2003 I have a document that has formulas in every cell. However, only some cells the area that contains the text and not the empty cells with formulas? - - Debra Ann Excel Programming Discussions ActiveSheet.PageSetup.PrintArea (1) Selection.EntireRow.Hidden (1) Microsoft Excel (1) PageSetup (1) VBA (1) VB (1) ICounter (1) Let’s (1) On Apr 8 special values of the cells you're checking that may or may not be empty. (concatenate if you need to) 2) loop through all these values, if the value is null Hidden = True end if next icounter HTH Chris keywords: Select, and, Print, only, Text description: Microsoft Excel 2003 I have a document that has formulas in every cell. However, only some