Thus, VLOOKUP(A3,'Life Input'!$A:$A,INDEX($C3,0))

Here is a visual:

National Revenue Allocation.xls | ||||||||
---|---|---|---|---|---|---|---|---|

A | B | C | D | E | F | |||

3 | KGBT | Barrington | 727,988 | #REF! | 50% | |||

4 | KTVO | Barrington | 307,672 | 307,672 | 50% | |||

5 | KXTU/KXRM | Barrington | 29,883 | 29,883 | 50% | |||

6 | WACH | Barrington | 54,221 | 54,221 | 50% | |||

7 | WLUC | Barrington | 485,912 | 485,912 | 50% | |||

8 | WNWO | Barrington | 288,808 | 288,808 | 50% | |||

9 | WPBN | Barrington | 204,169 | 204,169 | 50% | |||

10 | WSTM | Barrington | 494,209 | 494,209 | 50% | |||

11 | KCAU | Citadel | 101,219 | 101,219 | 50% | |||

Lifestyles |

I am trying to enter a formula the if the VLOOKUP is True to return the value from Column C thus, Offseting the reference (D3,0,-1)

The VLOOKUP formula is fine I am just having trouble with structuring multiple agruments. I believe OFFSET is the right argument if I want to return the value if true from D3 0rows and -1column, but my formula returns a REF! error

I would appreciated any advice possible

Thanks in advance,

Sean