vlookup

[Guest]

hi,
Why is it that whenever I use Vlookup, the first col in both sheets should
be the same..as in, both should be ids, or names or whatever...and that
should be the value on which im using vlookup? any way i can get around
having to delete/hide lots of cols everytime i use vlookup?

 

[Guest]

Are you using an equation like this:

=VLOOKUP(A1,Sheet2!A1:E100,5,false)

The 5 indicates which column of the range you've selected to pull the result
from.

If I'm missing something, let me know.

Barb Reinhardt

 

[Guest]

Use a lookup or even better look here for examples of an index/match

 

[Guest]

thanks John, will try doing tht

Use a lookup or even better look here for examples of an index/match