| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question about a range of cells
I have a few drop-down categories that make numerous product options but I
want to encourage the customers to pick the products we keep on stock. I have a list of the on hand products in cells B2 thru B88. Is there a way to use that range of cells in something like an IF statement where I can say €śon stock€ť if it falls in that range or €śspecial order€ť if it is not one of the 87 options we keep on hand? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Question about a range of cells
=IF(ISERROR(VLOOKUP($A$1,$B$2:$B$88,1,FALSE)),"Spe cial Order","On Stock")
where A1 contains the product selected. Hope this helps, Hutch "Cerberus" wrote: I have a few drop-down categories that make numerous product options but I want to encourage the customers to pick the products we keep on stock. I have a list of the on hand products in cells B2 thru B88. Is there a way to use that range of cells in something like an IF statement where I can say €śon stock€ť if it falls in that range or €śspecial order€ť if it is not one of the 87 options we keep on hand? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Question about a range of cells
Thank you for your help on this.
"Tom Hutchins" wrote: =IF(ISERROR(VLOOKUP($A$1,$B$2:$B$88,1,FALSE)),"Spe cial Order","On Stock") where A1 contains the product selected. Hope this helps, Hutch "Cerberus" wrote: I have a few drop-down categories that make numerous product options but I want to encourage the customers to pick the products we keep on stock. I have a list of the on hand products in cells B2 thru B88. Is there a way to use that range of cells in something like an IF statement where I can say €śon stock€ť if it falls in that range or €śspecial order€ť if it is not one of the 87 options we keep on hand? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When entering data into a range of cells, select the entire range. | Excel Discussion (Misc queries) | |||
| Find a range of values in a range of cells | Excel Worksheet Functions | |||
| how to compute a range of cells based on another range of cells? | Excel Worksheet Functions | |||
| how to compute a range of cells based on another range of cells? | Excel Worksheet Functions | |||
| Count cells in one range based on parameters in another range | Excel Worksheet Functions | |||
Linear Mode
