2 questions:

1st - in the vlookup formula is it possible to put a
formula in the lookup_value field instead of a cell
reference or text.

2nd - is there a vlookup macro or vb code available to
have a look at. I have had a search on the knowledge
base but cant seem to find one.

Kind regards

John Young