coltheplumb
Well-known Member
- Joined
- Nov 27, 2010
- Messages
- 731
Hi all
ok i have this formula in EF16 =if(CS16="1",vlookup(CP16,$QE$4:$ER$29,2)) ...it is returning FALSE what i am after is for it to return 3...which is the number that is next to what is in cell CP16.
all help appreciated
Colin X
ok i have this formula in EF16 =if(CS16="1",vlookup(CP16,$QE$4:$ER$29,2)) ...it is returning FALSE what i am after is for it to return 3...which is the number that is next to what is in cell CP16.
all help appreciated
Colin X