VIEW A TABLE
Hi Bhiravi, assuming your vlookup formula looks something like this:
=VLOOKUP(C8,customers,2,FALSE)
and you want to see the table "customers", you can type the name of the
range into the name box (the box that usually has the cell reference in it)
and excel should automatically select that range, if the range is in a hidden
sheet you will have to unhide the sheet first.
Hope this helps.
"Bhiravi" wrote:
I have just taken over maintenance of a form on Excel. This form has a cell
that refers to a VBLOOKUP function. How do I view the table/chart it is
referring to?
|