Hi all, hope you can help!

I am trying to look up a GL code (lets say code that is in A2), and in B2 I want to put the description of the GL code, normally I'd use v-lookup with a list in another sheet/book, however:

1. I can only have one sheet in the excel book;

2. I can't link to another excel book with the values in to do a vlookup

3. I can't put the list of GLs somewhere on the same page as the page that the GL code I'm looking up is on

I can use macro's etc, I think the three points above are the only likely sticking issues

any ideas how I can do this?

thanks,

Stan