Vlookup

B

Buxton

When doing a v'lookup do the lookup value and the table of array must be the
same format? see example below
example 000102025 table of array 102025 the zero was converted as text
would that affect my results.

Look up value table array column index range lookup
=Vlookup('fcapdata'!a:A,summer!$A:$GF,12False) why when I copied this
formula it still refers me to the previous worksheet that was used and when I
tried to edit the link it is giving me an error message.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top