How does one fix Vlookup references when the formula refers to another Sheet in the same worksheet. (I know how to use $ within a Sheet, but it doesn’t seem to work across Sheets).
Its OK, IE I sorted it out. I just had to make sure that I had the $'s in all the right places.