Vlookup Vertically
Hi guys,
basically I need a way of locating a name along a specified row and returning the value n rows below that name. For example I have a target cell with a dropdown list, when I select a name (ie "Dog") in that list I then need excel to identify this somewhere along row B and return the value that is two rows below it. Any help would be warmly appreciated. Many thanks in advance. Kind regards, Anthony |
Vlookup Vertically
Hi Anto
Use the Hlookup function (v = vertical, h = horizontal) "Anto111" wrote: Hi guys, basically I need a way of locating a name along a specified row and returning the value n rows below that name. For example I have a target cell with a dropdown list, when I select a name (ie "Dog") in that list I then need excel to identify this somewhere along row B and return the value that is two rows below it. Any help would be warmly appreciated. Many thanks in advance. Kind regards, Anthony |
Vlookup Vertically
Hi,
You question is confusing, there is no row B but maybe you mean this =HLOOKUP(A1,C2:Q12,11,FALSE) Mike "Anto111" wrote: Hi guys, basically I need a way of locating a name along a specified row and returning the value n rows below that name. For example I have a target cell with a dropdown list, when I select a name (ie "Dog") in that list I then need excel to identify this somewhere along row B and return the value that is two rows below it. Any help would be warmly appreciated. Many thanks in advance. Kind regards, Anthony |
Vlookup Vertically
Please get your terminology correct, Anthony - there is no row B, as B is a
column. Rows have numbers associated with them. It makes it very difficult to know what you want if you mix these things up. Pete "Anto111" wrote in message ... Hi guys, basically I need a way of locating a name along a specified row and returning the value n rows below that name. For example I have a target cell with a dropdown list, when I select a name (ie "Dog") in that list I then need excel to identify this somewhere along row B and return the value that is two rows below it. Any help would be warmly appreciated. Many thanks in advance. Kind regards, Anthony |
Vlookup Vertically
Many thanks Mike. apologies for not being clear I was in abit of a tizz
yesterday. Formula worked a treat anyway so thanks for the suggestion. Having looked at my database again, I can see that I need to take it one step further now. Basicaly I need to apply the same horizontal lookup and return the corresponding value a specific number of rows below but now I also need to return the value one column to the right also. So for example find the word "dog" in row 2 and return the value 3 rows below and one column to the right. All help would again be very warmly appreciated. Thanks in advance. Ant "Anto111" wrote: Hi guys, basically I need a way of locating a name along a specified row and returning the value n rows below that name. For example I have a target cell with a dropdown list, when I select a name (ie "Dog") in that list I then need excel to identify this somewhere along row B and return the value that is two rows below it. Any help would be warmly appreciated. Many thanks in advance. Kind regards, Anthony |
All times are GMT +1. The time now is 09:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com