Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Coding Error!
Hello
Having a little problem getting this code to work I tired many things including IF commands & VLOOKUP and I either get a N/A or False response from the codes I have tried. It consists of three columns listed below. A / B / C Column A: had random numbers from 1 to 8 Example: 1. 4 2. 5 3. 1 4. 8 Column B: Could have numbers from 17 to 45 being listed Example: 1. 17 2. 42 3. 25 4. 32 Column C is where I want the result to show either RFA1, RFA2 or UFA This depends on the two factors: Example: If column A =1 (A3) then lookup column B (B3) =25 Then LOOKUP this chart listed below: 25 = RFA2 17 = RFA1 18 = RFA1 19 = RFA1 20 = RFA1 21 = RFA1 22 = RFA1 23 = RFA1 24 = RFA1 25 = RFA2 26 = RFA2 27 = RFA2 28 = RFA2 29 = UFA 30 = UFA 31 = UFA 32 = UFA 33 = UFA 34 = UFA 35 = UFA 36 = UFA 37 = UFA 38 = UFA 39 = UFA 40 = UFA 41 = UFA 42 = UFA 43 = UFA 44 = UFA 45 = UFA The chart above will be listed on a separate page if needed, but Im thinking a chart may not be required. Any help would be appreciated |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Coding Error!
Hi!
What's the relation of column A to column B? Are you only interested in column A values of 1? If so: =IF(A1=1,IF(ISNUMBER(B1),LOOKUP(B1,{0;17;25;29},{" ";"RFA1";"RFA2";"UFA"}),""),"") Biff "Killer" wrote in message ... Hello Having a little problem getting this code to work I tired many things including IF commands & VLOOKUP and I either get a N/A or False response from the codes I have tried. It consists of three columns listed below. A / B / C Column A: had random numbers from 1 to 8 Example: 1. 4 2. 5 3. 1 4. 8 Column B: Could have numbers from 17 to 45 being listed Example: 1. 17 2. 42 3. 25 4. 32 Column C is where I want the result to show either RFA1, RFA2 or UFA This depends on the two factors: Example: If column A =1 (A3) then lookup column B (B3) =25 Then LOOKUP this chart listed below: 25 = RFA2 17 = RFA1 18 = RFA1 19 = RFA1 20 = RFA1 21 = RFA1 22 = RFA1 23 = RFA1 24 = RFA1 25 = RFA2 26 = RFA2 27 = RFA2 28 = RFA2 29 = UFA 30 = UFA 31 = UFA 32 = UFA 33 = UFA 34 = UFA 35 = UFA 36 = UFA 37 = UFA 38 = UFA 39 = UFA 40 = UFA 41 = UFA 42 = UFA 43 = UFA 44 = UFA 45 = UFA The chart above will be listed on a separate page if needed, but I'm thinking a chart may not be required. Any help would be appreciated |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Coding Error!
Actually both columns are required.
Because if column A1 =1 then it should look into column B1 and get the information from there then look into the chart below. To give the value in column C1 17 = RFA1 18 = RFA1 19 = RFA1 20 = RFA1 21 = RFA1 22 = RFA1 23 = RFA1 24 = RFA1 25 = RFA2 26 = RFA2 27 = RFA2 28 = RFA2 29 = UFA 30 = UFA 31 = UFA 32 = UFA 33 = UFA 34 = UFA 35 = UFA 36 = UFA 37 = UFA 38 = UFA 39 = UFA 40 = UFA 41 = UFA 42 = UFA 43 = UFA 44 = UFA 45 = UFA Thanks for the help Biff "Biff" wrote: Hi! What's the relation of column A to column B? Are you only interested in column A values of 1? If so: =IF(A1=1,IF(ISNUMBER(B1),LOOKUP(B1,{0;17;25;29},{" ";"RFA1";"RFA2";"UFA"}),""),"") Biff "Killer" wrote in message ... Hello Having a little problem getting this code to work I tired many things including IF commands & VLOOKUP and I either get a N/A or False response from the codes I have tried. It consists of three columns listed below. A / B / C Column A: had random numbers from 1 to 8 Example: 1. 4 2. 5 3. 1 4. 8 Column B: Could have numbers from 17 to 45 being listed Example: 1. 17 2. 42 3. 25 4. 32 Column C is where I want the result to show either RFA1, RFA2 or UFA This depends on the two factors: Example: If column A =1 (A3) then lookup column B (B3) =25 Then LOOKUP this chart listed below: 25 = RFA2 17 = RFA1 18 = RFA1 19 = RFA1 20 = RFA1 21 = RFA1 22 = RFA1 23 = RFA1 24 = RFA1 25 = RFA2 26 = RFA2 27 = RFA2 28 = RFA2 29 = UFA 30 = UFA 31 = UFA 32 = UFA 33 = UFA 34 = UFA 35 = UFA 36 = UFA 37 = UFA 38 = UFA 39 = UFA 40 = UFA 41 = UFA 42 = UFA 43 = UFA 44 = UFA 45 = UFA The chart above will be listed on a separate page if needed, but I'm thinking a chart may not be required. Any help would be appreciated |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Coding Error!
Ok I tried that code and it seems to work great but theres one little
problem it only works a blank worksheet but not the sheet that I have all my data. The data sheet its not listing anything leaving it blank. What could that be? "Killer" wrote: Actually both columns are required. Because if column A1 =1 then it should look into column B1 and get the information from there then look into the chart below. To give the value in column C1 17 = RFA1 18 = RFA1 19 = RFA1 20 = RFA1 21 = RFA1 22 = RFA1 23 = RFA1 24 = RFA1 25 = RFA2 26 = RFA2 27 = RFA2 28 = RFA2 29 = UFA 30 = UFA 31 = UFA 32 = UFA 33 = UFA 34 = UFA 35 = UFA 36 = UFA 37 = UFA 38 = UFA 39 = UFA 40 = UFA 41 = UFA 42 = UFA 43 = UFA 44 = UFA 45 = UFA Thanks for the help Biff "Biff" wrote: Hi! What's the relation of column A to column B? Are you only interested in column A values of 1? If so: =IF(A1=1,IF(ISNUMBER(B1),LOOKUP(B1,{0;17;25;29},{" ";"RFA1";"RFA2";"UFA"}),""),"") Biff "Killer" wrote in message ... Hello Having a little problem getting this code to work I tired many things including IF commands & VLOOKUP and I either get a N/A or False response from the codes I have tried. It consists of three columns listed below. A / B / C Column A: had random numbers from 1 to 8 Example: 1. 4 2. 5 3. 1 4. 8 Column B: Could have numbers from 17 to 45 being listed Example: 1. 17 2. 42 3. 25 4. 32 Column C is where I want the result to show either RFA1, RFA2 or UFA This depends on the two factors: Example: If column A =1 (A3) then lookup column B (B3) =25 Then LOOKUP this chart listed below: 25 = RFA2 17 = RFA1 18 = RFA1 19 = RFA1 20 = RFA1 21 = RFA1 22 = RFA1 23 = RFA1 24 = RFA1 25 = RFA2 26 = RFA2 27 = RFA2 28 = RFA2 29 = UFA 30 = UFA 31 = UFA 32 = UFA 33 = UFA 34 = UFA 35 = UFA 36 = UFA 37 = UFA 38 = UFA 39 = UFA 40 = UFA 41 = UFA 42 = UFA 43 = UFA 44 = UFA 45 = UFA The chart above will be listed on a separate page if needed, but I'm thinking a chart may not be required. Any help would be appreciated |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Coding Error!
Ok, I'm not understanding this!
Actually both columns are required. How? What is the relation? Based on you posted sample: A...........B..........C 4...........17 5...........42 1...........25 8...........32 What results would you expect in column C? Biff "Killer" wrote in message ... Ok I tried that code and it seems to work great but there's one little problem it only works a blank worksheet but not the sheet that I have all my data. The data sheet it's not listing anything leaving it blank. What could that be? "Killer" wrote: Actually both columns are required. Because if column A1 =1 then it should look into column B1 and get the information from there then look into the chart below. To give the value in column C1 17 = RFA1 18 = RFA1 19 = RFA1 20 = RFA1 21 = RFA1 22 = RFA1 23 = RFA1 24 = RFA1 25 = RFA2 26 = RFA2 27 = RFA2 28 = RFA2 29 = UFA 30 = UFA 31 = UFA 32 = UFA 33 = UFA 34 = UFA 35 = UFA 36 = UFA 37 = UFA 38 = UFA 39 = UFA 40 = UFA 41 = UFA 42 = UFA 43 = UFA 44 = UFA 45 = UFA Thanks for the help Biff "Biff" wrote: Hi! What's the relation of column A to column B? Are you only interested in column A values of 1? If so: =IF(A1=1,IF(ISNUMBER(B1),LOOKUP(B1,{0;17;25;29},{" ";"RFA1";"RFA2";"UFA"}),""),"") Biff "Killer" wrote in message ... Hello Having a little problem getting this code to work I tired many things including IF commands & VLOOKUP and I either get a N/A or False response from the codes I have tried. It consists of three columns listed below. A / B / C Column A: had random numbers from 1 to 8 Example: 1. 4 2. 5 3. 1 4. 8 Column B: Could have numbers from 17 to 45 being listed Example: 1. 17 2. 42 3. 25 4. 32 Column C is where I want the result to show either RFA1, RFA2 or UFA This depends on the two factors: Example: If column A =1 (A3) then lookup column B (B3) =25 Then LOOKUP this chart listed below: 25 = RFA2 17 = RFA1 18 = RFA1 19 = RFA1 20 = RFA1 21 = RFA1 22 = RFA1 23 = RFA1 24 = RFA1 25 = RFA2 26 = RFA2 27 = RFA2 28 = RFA2 29 = UFA 30 = UFA 31 = UFA 32 = UFA 33 = UFA 34 = UFA 35 = UFA 36 = UFA 37 = UFA 38 = UFA 39 = UFA 40 = UFA 41 = UFA 42 = UFA 43 = UFA 44 = UFA 45 = UFA The chart above will be listed on a separate page if needed, but I'm thinking a chart may not be required. Any help would be appreciated |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Coding Error!
The code you posted first works fine Biff Thanks... Just for some strange
season it's not showing anything if I add the code to a data sheet I have created but works fine if I create a new sheet... Weird I must say. "Biff" wrote: Ok, I'm not understanding this! Actually both columns are required. How? What is the relation? Based on you posted sample: A...........B..........C 4...........17 5...........42 1...........25 8...........32 What results would you expect in column C? Biff "Killer" wrote in message ... Ok I tried that code and it seems to work great but there's one little problem it only works a blank worksheet but not the sheet that I have all my data. The data sheet it's not listing anything leaving it blank. What could that be? "Killer" wrote: Actually both columns are required. Because if column A1 =1 then it should look into column B1 and get the information from there then look into the chart below. To give the value in column C1 17 = RFA1 18 = RFA1 19 = RFA1 20 = RFA1 21 = RFA1 22 = RFA1 23 = RFA1 24 = RFA1 25 = RFA2 26 = RFA2 27 = RFA2 28 = RFA2 29 = UFA 30 = UFA 31 = UFA 32 = UFA 33 = UFA 34 = UFA 35 = UFA 36 = UFA 37 = UFA 38 = UFA 39 = UFA 40 = UFA 41 = UFA 42 = UFA 43 = UFA 44 = UFA 45 = UFA Thanks for the help Biff "Biff" wrote: Hi! What's the relation of column A to column B? Are you only interested in column A values of 1? If so: =IF(A1=1,IF(ISNUMBER(B1),LOOKUP(B1,{0;17;25;29},{" ";"RFA1";"RFA2";"UFA"}),""),"") Biff "Killer" wrote in message ... Hello Having a little problem getting this code to work I tired many things including IF commands & VLOOKUP and I either get a N/A or False response from the codes I have tried. It consists of three columns listed below. A / B / C Column A: had random numbers from 1 to 8 Example: 1. 4 2. 5 3. 1 4. 8 Column B: Could have numbers from 17 to 45 being listed Example: 1. 17 2. 42 3. 25 4. 32 Column C is where I want the result to show either RFA1, RFA2 or UFA This depends on the two factors: Example: If column A =1 (A3) then lookup column B (B3) =25 Then LOOKUP this chart listed below: 25 = RFA2 17 = RFA1 18 = RFA1 19 = RFA1 20 = RFA1 21 = RFA1 22 = RFA1 23 = RFA1 24 = RFA1 25 = RFA2 26 = RFA2 27 = RFA2 28 = RFA2 29 = UFA 30 = UFA 31 = UFA 32 = UFA 33 = UFA 34 = UFA 35 = UFA 36 = UFA 37 = UFA 38 = UFA 39 = UFA 40 = UFA 41 = UFA 42 = UFA 43 = UFA 44 = UFA 45 = UFA The chart above will be listed on a separate page if needed, but I'm thinking a chart may not be required. Any help would be appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sharing Violation Error while opening Excel file with Win Runner | Excel Discussion (Misc queries) | |||
Recurring Excel Formula error - multiple users affected! | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Run-time Error in Excel? | Excel Worksheet Functions | |||
Downloading Templates for Excel error with a windows error. | Excel Discussion (Misc queries) |