LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Killer
 
Posts: n/a
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sharing Violation Error while opening Excel file with Win Runner prabhu Excel Discussion (Misc queries) 0 April 20th 06 06:52 PM
Recurring Excel Formula error - multiple users affected! Rayo K Excel Discussion (Misc queries) 3 April 11th 06 02:22 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
Run-time Error in Excel? Elena Excel Worksheet Functions 0 April 20th 05 04:26 PM
Downloading Templates for Excel error with a windows error. Lanie Moore Excel Discussion (Misc queries) 0 December 20th 04 11:39 PM


All times are GMT +1. The time now is 10:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"