if you go into help and look up the vlookup function (no pun intended) that should help you out. One of the arguments in the function is a range. It could be defined as in A1:E27 format, or it could be a named range, like MyDataRange. If it is the latter, you can go into the Insert-Names-Define menu and change the range, and then add your new data inside the new range.
Like this thread? Share it with others