Forum Discussion
Excel Formula
Hello Everyone, I am fairly new to using Excel and just had something dropped in my lap that I have to deal with. We had a former employee create a form that autofills with information from a progra...
pperry The core of this formula is the VLOOKUP - that's the part that looks for a value on another sheet. This one takes the value from A102 and looks for it in the A column of the Receipt Types sheet, and returns the corresponding value from column B.
If that fails, it will return an N/A error. The IF / ISNA parts are just there to make the formula return a 0 instead of that.
The ! are how references to other sheets are written. The $ help with formula copy-pasting. If you copy a formula like =A1 down to the next cell, you get =A2. But with $s in there it doesn't change. That lets you copy the formula down on your current sheet without moving the references to the table on the other sheet too.