I'll start this thread with mentioning that I am from Norway, so sorry
for my english, but I hope you'll understand what i mean.

I have createt a formula that gets information from another .xls
document and the formula is like this:

VLOOKUP(B7;[konverteringsliste.xls]Sheet1!$A$1:$B$769;2;FALSE)

By now, the last cell in konverteringsliste.xls is B769. But it may be
updated with more cells, and thats where the problems start. I want the
VLOOKUP function to search through the whole excel document. If the list
gets updated, the last cell may be B844, and then, my old formula stills
searches from A1:B769. Is there any command, formula or function i can
do, that will automatically search through the whole excel workbook?


--
Anders Salbu
------------------------------------------------------------------------
Anders Salbu's Profile: http://www.excelforum.com/member.php...o&userid=32259
View this thread: http://www.excelforum.com/showthread...hreadid=520075