Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function
In a worksheet, I have a list cell(A1) that contains the words "Bodily
Injury", "Property Damage", and "Other". In the next cell(A2), I would need a function that says: if A1 contaisn the word "bodily Injury" then go to "Bodily Injury list" (which is on another worksheet). But if A1 contains the word "Property Damage" then go to "Property Damage list". but if A1 contains the "Other" then go to "Other list". Hopefully you can help Thank You |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function
Visit he
http://www.contextures.com/xlDataVal02.html for a technique to do what you (apparently) want. HTH, Bernie MS Excel MVP "organbylady" wrote in message ... In a worksheet, I have a list cell(A1) that contains the words "Bodily Injury", "Property Damage", and "Other". In the next cell(A2), I would need a function that says: if A1 contaisn the word "bodily Injury" then go to "Bodily Injury list" (which is on another worksheet). But if A1 contains the word "Property Damage" then go to "Property Damage list". but if A1 contains the "Other" then go to "Other list". Hopefully you can help Thank You |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function
Thank You. This is just what I was looking for!!!!
"Bernie Deitrick" wrote: Visit he http://www.contextures.com/xlDataVal02.html for a technique to do what you (apparently) want. HTH, Bernie MS Excel MVP "organbylady" wrote in message ... In a worksheet, I have a list cell(A1) that contains the words "Bodily Injury", "Property Damage", and "Other". In the next cell(A2), I would need a function that says: if A1 contaisn the word "bodily Injury" then go to "Bodily Injury list" (which is on another worksheet). But if A1 contains the word "Property Damage" then go to "Property Damage list". but if A1 contains the "Other" then go to "Other list". Hopefully you can help Thank You |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |