Home |
Search |
Today's Posts |
#1
|
|||
|
|||
vertical and horizontal lookup?
Hi guys, new to the forum.
I'm trying to look up some data in two different worksheets dependent on the row and column, the attached is the data i want to look up. So basically I'll have a carbon copy of this spreadsheet and I want to say lookup "a" in row and return aug data from column, lookup "a" in row and return sep data etc, then it will be lookup "b" in row and return aug data, lookup "b" in row and return sep data. I'm pretty sure it's something to do with index and lookup but can't figure it out. Thanks in advance |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vertical and horizontal lookup?
On Thursday, June 14, 2012 3:36:29 PM UTC+5:30, tealy wrote:
Hi guys, new to the forum. I'm trying to look up some data in two different worksheets dependent on the row and column, the attached is the data i want to look up. So basically I'll have a carbon copy of this spreadsheet and I want to say lookup "a" in row and return aug data from column, lookup "a" in row and return sep data etc, then it will be lookup "b" in row and return aug data, lookup "b" in row and return sep data. I'm pretty sure it's something to do with index and lookup but can't figure it out. Thanks in advance +-------------------------------------------------------------------+ |Filename: Book1 (2).zip | |Download: http://www.excelbanter.com/attachment.php?attachmentid=422| +-------------------------------------------------------------------+ -- tealy Try this =VLOOKUP($A16,$A$1:$K$6,COLUMN(B:B),FALSE) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need an Excell function that can lookup vertical AND horizontal | Excel Worksheet Functions | |||
Horizontal and Vertical lookup | Excel Worksheet Functions | |||
Vertical to Horizontal | Excel Discussion (Misc queries) | |||
Need lookup of data both vertical and horizontal | Excel Discussion (Misc queries) | |||
Vertical to horizontal | Excel Discussion (Misc queries) |