I am trying to perform a VLOOKUP from one ws to another for the value in column A
Thus, VLOOKUP(A3,'Life Input'!$A:$A,INDEX($C3,0))
Here is a visual:
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
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