VLOOKUP

S

steph44haf

I am having trouble with VLOOKUP. I am getting memory errors. Can I use the
VLOOKUP formula to look up data in an external workbook or does the data have
to be in the same workbook?

Any help would be great.

Thanks,

Steph
 
F

Franz Verga

steph44haf said:
I am having trouble with VLOOKUP. I am getting memory errors. Can I
use the VLOOKUP formula to look up data in an external workbook or
does the data have to be in the same workbook?

Any help would be great.

Thanks,

Steph
Click to expand...

Hi Steph,

The data you are looking in with VLOOKUP don't need to be in the same
workbook of the formula you are using. Maybe the table you are looking in is
too big for your PC memory...


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
M

mr_ben

you can link to external spreadsheets.


as for memory it depends on how much data you have...
 
F

Franz Verga

steph44haf said:
Can I have a formula in my lookup value? It isn't working sometimes.
Click to expand...

Try to describe your situation and to post the formula that is not
working...



--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
Top