| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
| IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Linear Mode
