Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Function needed please
hI
I am a beginner in excel and trying to work out a formula / function which help me work easier and quicker. I will get straight into it. If cell A1 = Lettuce and A2 = Orange and A3= Carrot, how do I make columns B1 and B3 categroise these as vegetables by using a function? I hope this makes sense Thanks Stadinx |
#2
|
|||
|
|||
If you are only going to have Lettuce, Orange or Carrot then you can enter a
formula like this into cell B1 and copy it down: =IF(A1="Orange","Fruit","Vegetable") In the more likely case where your list contains more than just these three you should have a lookup list and use the vlookup function. The lookup list can be on the same sheet, a different sheet or even a different workbook. It will hold a list of all Options and their categories. So my lookup list is on Sheet2 with the Options in Column A and the categories in Column B something like this: Orange Fruit Lettuce Vegetable Carrot Vegetable Pear Fruit Back on sheet1 in Cell B1 I can then add the formula =VLOOKUP(A1,Sheet2!$A$1:$B$3,2,0) and copy it down. See help on vlookup for more information. Hope this helps Rowan "Stadinx" wrote: hI I am a beginner in excel and trying to work out a formula / function which help me work easier and quicker. I will get straight into it. If cell A1 = Lettuce and A2 = Orange and A3= Carrot, how do I make columns B1 and B3 categroise these as vegetables by using a function? I hope this makes sense Thanks Stadinx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Day of week function needed | Excel Worksheet Functions | |||
Help needed with IF function | Excel Worksheet Functions | |||
function needed | Excel Worksheet Functions | |||
IF function help needed | Excel Worksheet Functions | |||
Urgent help needed: IF function | Excel Worksheet Functions |