#### S.H.A.D.O.

##### Well-known Member

- Joined
- Sep 6, 2005

- Messages
- 1,915

I have the formula:

Code:

```
=IF(SUMPRODUCT(COUNTIF($G22:$K22,VLOOKUP($B$3,Master!$B$16:$U$2016,{14,15,16,17,18,19})))
=3,VLOOKUP(3,$B$20:$D$27,{3}),"W")
```

...which works OK if I hard code the number into it.

But I want to replace the

**3**with a cell reference where there are alpha characters at the beginning and then a space and then a

**SINGLE**numeric value.

There are quite a few so getting the formula to work will save time.

So I changed the formula to:

Code:

```
=IF(SUMPRODUCT(COUNTIF($G22:$K22,VLOOKUP($B$3,Master!$B$16:$U$2016,{14,15,16,17,18,19})))
=RIGHT(F22,1),VLOOKUP(RIGHT(F22,1),$B$20:$D$27,{3}),"W")
```

As I said, the first formula gives me the correct result so I know that part of it is OK.

Ant help will be appreciated.

Thanks in advance.