|
vlookup for mutiple rows
question for you..
i want to use a vlookup like feature to get data from more than one row. so lets say column A has my lookup value.. i need it to find the row with the value i am searching for and return columns b,c,d,e,f (all columns are consecutive) and paste those values in columns b,c,d,e,f in a different worksheet. i know i can go to each individual cell and do its own vlookup.. but is there anyway to do it all with one command and not go to each cell and type out the vlook up function? |
vlookup for mutiple rows
Use something like this:
=VLOOKUP($A1,Sheet2!$A1:$F10,COLUMNS($A:B),0) Then just drag copy across Biff "mithu" wrote in message oups.com... question for you.. i want to use a vlookup like feature to get data from more than one row. so lets say column A has my lookup value.. i need it to find the row with the value i am searching for and return columns b,c,d,e,f (all columns are consecutive) and paste those values in columns b,c,d,e,f in a different worksheet. i know i can go to each individual cell and do its own vlookup.. but is there anyway to do it all with one command and not go to each cell and type out the vlook up function? |
vlookup for mutiple rows
Thanks that worked great
On Mar 21, 1:32 pm, "T. Valko" wrote: Use something like this: =VLOOKUP($A1,Sheet2!$A1:$F10,COLUMNS($A:B),0) Then just drag copy across Biff "mithu" wrote in message oups.com... question for you.. i want to use a vlookup like feature to get data from more than one row. so lets say column A has my lookup value.. i need it to find the row with the value i am searching for and return columns b,c,d,e,f (all columns are consecutive) and paste those values in columns b,c,d,e,f in a different worksheet. i know i can go to each individual cell and do its own vlookup.. but is there anyway to do it all with one command and not go to each cell and type out the vlook up function?- Hide quoted text - - Show quoted text - |
vlookup for mutiple rows
You're welcome. Thanks for the feedback!
Biff "mithu" wrote in message ups.com... Thanks that worked great On Mar 21, 1:32 pm, "T. Valko" wrote: Use something like this: =VLOOKUP($A1,Sheet2!$A1:$F10,COLUMNS($A:B),0) Then just drag copy across Biff "mithu" wrote in message oups.com... question for you.. i want to use a vlookup like feature to get data from more than one row. so lets say column A has my lookup value.. i need it to find the row with the value i am searching for and return columns b,c,d,e,f (all columns are consecutive) and paste those values in columns b,c,d,e,f in a different worksheet. i know i can go to each individual cell and do its own vlookup.. but is there anyway to do it all with one command and not go to each cell and type out the vlook up function?- Hide quoted text - - Show quoted text - |
vlookup for mutiple rows
hmm its really wierd.. does the absolute cell references have to be in
there =VLOOKUP($A1,Sheet2!$A1:$F10,COLUMNS($A:B),0) can be done with out absolute cell references On Mar 21, 2:11 pm, "T. Valko" wrote: You're welcome. Thanks for the feedback! Biff "mithu" wrote in message ups.com... Thanks that worked great On Mar 21, 1:32 pm, "T. Valko" wrote: Use something like this: =VLOOKUP($A1,Sheet2!$A1:$F10,COLUMNS($A:B),0) Then just drag copy across Biff "mithu" wrote in message groups.com... question for you.. i want to use a vlookup like feature to get data from more than one row. so lets say column A has my lookup value.. i need it to find the row with the value i am searching for and return columns b,c,d,e,f (all columns are consecutive) and paste those values in columns b,c,d,e,f in a different worksheet. i know i can go to each individual cell and do its own vlookup.. but is there anyway to do it all with one command and not go to each cell and type out the vlook up function?- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
vlookup for mutiple rows
The only one that knows for sure is you. I can't see what you're doing! I
can only give my best suggestion based on what you've told us. If you make the references relative and copy across this is what you'll get: =VLOOKUP(A1,Sheet2!A1:F10,COLUMNS(A:B),0) =VLOOKUP(B1,Sheet2!B1:G10,COLUMNS(B:C),0) =VLOOKUP(C1,Sheet2!C1:H10,COLUMNS(C:D),0) etc Biff "mithu" wrote in message oups.com... hmm its really wierd.. does the absolute cell references have to be in there =VLOOKUP($A1,Sheet2!$A1:$F10,COLUMNS($A:B),0) can be done with out absolute cell references On Mar 21, 2:11 pm, "T. Valko" wrote: You're welcome. Thanks for the feedback! Biff "mithu" wrote in message ups.com... Thanks that worked great On Mar 21, 1:32 pm, "T. Valko" wrote: Use something like this: =VLOOKUP($A1,Sheet2!$A1:$F10,COLUMNS($A:B),0) Then just drag copy across Biff "mithu" wrote in message groups.com... question for you.. i want to use a vlookup like feature to get data from more than one row. so lets say column A has my lookup value.. i need it to find the row with the value i am searching for and return columns b,c,d,e,f (all columns are consecutive) and paste those values in columns b,c,d,e,f in a different worksheet. i know i can go to each individual cell and do its own vlookup.. but is there anyway to do it all with one command and not go to each cell and type out the vlook up function?- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
vlookup for mutiple rows
Ok i am getting it.
Thanks for you help biff On Mar 21, 4:27 pm, "T. Valko" wrote: The only one that knows for sure is you. I can't see what you're doing! I can only give my best suggestion based on what you've told us. If you make the references relative and copy across this is what you'll get: =VLOOKUP(A1,Sheet2!A1:F10,COLUMNS(A:B),0) =VLOOKUP(B1,Sheet2!B1:G10,COLUMNS(B:C),0) =VLOOKUP(C1,Sheet2!C1:H10,COLUMNS(C:D),0) etc Biff "mithu" wrote in message oups.com... hmm its really wierd.. does the absolute cell references have to be in there =VLOOKUP($A1,Sheet2!$A1:$F10,COLUMNS($A:B),0) can be done with out absolute cell references On Mar 21, 2:11 pm, "T. Valko" wrote: You're welcome. Thanks for the feedback! Biff "mithu" wrote in message roups.com... Thanks that worked great On Mar 21, 1:32 pm, "T. Valko" wrote: Use something like this: =VLOOKUP($A1,Sheet2!$A1:$F10,COLUMNS($A:B),0) Then just drag copy across Biff "mithu" wrote in message groups.com... question for you.. i want to use a vlookup like feature to get data from more than one row. so lets say column A has my lookup value.. i need it to find the row with the value i am searching for and return columns b,c,d,e,f (all columns are consecutive) and paste those values in columns b,c,d,e,f in a different worksheet. i know i can go to each individual cell and do its own vlookup.. but is there anyway to do it all with one command and not go to each cell and type out the vlook up function?- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
| All times are GMT +1. The time now is 12:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com