Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What function(s) should i use?
Hello All, a newbe here...
I want to know what function(s) to use with this question. Question: -inside a cell i have the word <Null, cells(65536,10) -i want to check another cell for it's value or at least a part of it's text value [don't want exact full string], cells(65536,4) -then i want to have the value from cells(65536,4) [value could be DEV], look up the text in a lookup table, located in another sheet from the main sheet the table would be something like... A2-DEV, B2-Development, A3-POC, B3-proof of concept, etc... -then i want it to grab the 2nd column [name-Development in B2] and replace <Null value within the cells(65536,10) with [Development] as the name. Is this possible? I have been studying Vlookup and Index/Match. i am not sure how to go about it. Thanks all for any ideas. Keri Taylor |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
What function(s) should i use?
The closest I can get is to put the formula where you want the result
like this: J65536 = VLookup(D65536,Sheet1!A:B,2) This will grab the value of cell D65536, compare it to the range A:B and return the value in the second column of the array. I'm not quite sure what you're trying to do with the null statement. Let me know if you need more help. HTH Die_Another_Day FurRelKT wrote: Hello All, a newbe here... I want to know what function(s) to use with this question. Question: -inside a cell i have the word <Null, cells(65536,10) -i want to check another cell for it's value or at least a part of it's text value [don't want exact full string], cells(65536,4) -then i want to have the value from cells(65536,4) [value could be DEV], look up the text in a lookup table, located in another sheet from the main sheet the table would be something like... A2-DEV, B2-Development, A3-POC, B3-proof of concept, etc... -then i want it to grab the 2nd column [name-Development in B2] and replace <Null value within the cells(65536,10) with [Development] as the name. Is this possible? I have been studying Vlookup and Index/Match. i am not sure how to go about it. Thanks all for any ideas. Keri Taylor |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
What function(s) should i use?
Thanks so very much~ It does work! However i am putting in a IF
statements like this... =IF(I374 = "TEST","''",VLOOKUP(I374,Clients!$A$2:$B$296,2,TRU E)) I want it to check if the value is TEST, if it is then leave it, else go to the lookup table to find the correct lookup for the value. Is there a way to leave the cell value? I put "" but that is not right. What do i need to put in the condition if it is true to just leave the contents of the cell the way it is? Thanks for any help provided. Keri~ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
What function(s) should i use?
Thanks so very much~ It does work! However i am putting in a IF
statements like this... =IF(I374 = "TEST","''",VLOOKUP(I374,Clients!$A$2:$B$296,2,TRU E)) I want it to check if the value is TEST, if it is then leave it, else go to the lookup table to find the correct lookup for the value. Is there a way to leave the cell value? I put "" but that is not right. What do i need to put in the condition if it is true to just leave the contents of the cell the way it is? Thanks for any help provided. Keri~ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
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 | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Adding a custom function to the default excel function list | Excel Programming |