Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |