vertical and horizontal lookup?

T

tealy

Hi guys, new to the forum.

I'm trying to look up some data in two different worksheets dependent o
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 t
say lookup "a" in row and return aug data from column, lookup "a" in ro
and return sep data etc, then it will be lookup "b" in row and retur
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'
figure it out.

Thanks in advanc

+-------------------------------------------------------------------
|Filename: Book1 (2).zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=422
+-------------------------------------------------------------------
 
H

hardeep.kanwar

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|

+-------------------------------------------------------------------+

Try this

=VLOOKUP($A16,$A$1:$K$6,COLUMN(B:B),FALSE)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top