Celticshadow
Active Member
- Joined
- Aug 16, 2010
- Messages
- 414
- Office Version
- 365
- Platform
- Windows
Hi Everyone
May I ask forum if they would be kind enough to look at the below and help me with a solution to find the correct formula for looking up the value associated with the text in Col A2 from a separate tab named RT Lists. I trust the attached worksheet is suffice and clear.
Regards
<tbody>
</tbody>
May I ask forum if they would be kind enough to look at the below and help me with a solution to find the correct formula for looking up the value associated with the text in Col A2 from a separate tab named RT Lists. I trust the attached worksheet is suffice and clear.
Regards
A | B | C | D | E | F | G | H | I | J | K | |
1 | Going | Res | |||||||||
2 | GF | 1 | =IFERROR(VLOOKUP(A2,'RT List'!$U$2:$V$35,2),0) | ||||||||
3 | GD | 1 | =IFERROR(VLOOKUP(A3,'RT List'!$U$2:$V$35,2),0) | ||||||||
4 | GD | 1 | =IFERROR(VLOOKUP(A4,'RT List'!$U$2:$V$35,2),0) | ||||||||
5 | GF | 1 | =IFERROR(VLOOKUP(A5,'RT List'!$U$2:$V$35,2),0) | RT | Lists | ||||||
6 | St | 1 | =IFERROR(VLOOKUP(A6,'RT List'!$U$2:$V$35,2),0) | Flt Going | Value | ||||||
7 | GF | 1 | =IFERROR(VLOOKUP(A7,'RT List'!$U$2:$V$35,2),0) | F | 1 | ||||||
8 | FM | 1 | |||||||||
9 | G | 1 | |||||||||
10 | GD | 1 | |||||||||
11 | GF | 1 | |||||||||
12 | GS | 1 | |||||||||
13 | Hd | 1 | |||||||||
14 | Hy | 1 | |||||||||
15 | Hyv | 1 | |||||||||
16 | S | 1 | |||||||||
17 | Sft | 1 | |||||||||
18 | VSft | 1 | |||||||||
19 | Yld | 1 | |||||||||
20 | Column B2 down is looking at the text in Col A 2 down and trying to find the value associated with it in the tab "RT Lists. So for example if GF is in A2 then look at tab RT lists and find text GF and the value associated with it in the adjacent column in this case it is 1. Unfortunately the formula I am using is not doing the task correctly (probably as it is an incorrect formula for the job) | ||||||||||
21 | |||||||||||
22 | |||||||||||
<tbody>
</tbody>