VBlookup - problem (excel 97)

I have a group of data (GL Account Numbers) that are on a sperate sheet
that is already opened. I want to take the description that I get on my
first page and store that to a variable name then switch sheets and find
that description. Once I have found it I want to store off the account
numbers and then place them on the first sheet. I think it is VBLOOKUP.

where the arguments tie in to the above example:
what you want to look for,
the range you want to search,
the column of that range to return results from and
an optional flag that indicates both whether an approximate match is to be made and whether the data is sorted. in your case, if you are dragging descriptions from a chart of accounts as I suspect then the data will be sorted but the more important factor here is that you need an exact match, so should specify FALSE. (ommitted = true)

note that a lot of problems occur when trying to search for the text string 300500 in a list of numbers that contain the number 300500 or vice versa. If this is the case no match will be made, so make sure that the formats are the same.