Need a bit more excel help.
Using the vlookup function to fill in prices for my pay sheets. Been working good so far. As such, the company has chenged the pay sheet format slightly. So I need to revise my version.
Anyway, I need to know if it is possible to use a null or blank value. Currently I'm using a "space" for my data point which returns a dollar value. What I'd like to do if possible is not to have to put a bunch of "spaces" all over my paysheet. Basicly, if I leave a certain cell blank (nothing at all in it) the vlookup will return a value say $0.00.
Make sense?
Using the vlookup function to fill in prices for my pay sheets. Been working good so far. As such, the company has chenged the pay sheet format slightly. So I need to revise my version.
Anyway, I need to know if it is possible to use a null or blank value. Currently I'm using a "space" for my data point which returns a dollar value. What I'd like to do if possible is not to have to put a bunch of "spaces" all over my paysheet. Basicly, if I leave a certain cell blank (nothing at all in it) the vlookup will return a value say $0.00.
Make sense?
Facebook
Twitter