EchoDelta
New member
- Joined
- Feb 28, 2015
- Messages
- 8
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2013
Is it possible to incorporate truncation (TRUNC or INT) within VLOOKUP function? I have a formula and it works just fine except the result is not always a whole number. I have another formula which looks at this result but requires a whole number.
Formula is:
= VLOOKUP(J2,'[Handicap.xlsm]'!$A$6:$F$209,6,)
Thanks,
Ed
Formula is:
= VLOOKUP(J2,'[Handicap.xlsm]'!$A$6:$F$209,6,)
Thanks,
Ed