vlookup
 

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?

vlookup
 

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

"swati" wrote:

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?

vlookup
 

Use a lookup or even better look here for examples of an index/match
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"swati" wrote:

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?

vlookup
 

thanks John, will try doing tht

"John Bundy" wrote:

Use a lookup or even better look here for examples of an index/match
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"swati" wrote:

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?