v and h lookup

volkl77

Board Regular
Joined
Apr 5, 2008
Messages
76
Is there any formula that provides the combined fuctionality of both v and h lookup together? thanks!
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
You'll probably need to be more specific about what you want to do, but sounds like INDEX(MATCH would do what you want..

Here's a small example

Excel Workbook
ABCD
1RedBlueGreen
2Chevy147
3Ford258
4Toyota369
5
6
7FindBlueFord
8
95
Sheet1
 

volkl77

Board Regular
Joined
Apr 5, 2008
Messages
76
sorry, I will explain myself a little better.

I have sheet A with dates across the top row and categories down the first column. On sheet B I need a formula that will reference the value of a cell on sheet A by date and category.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,523
Messages
5,529,334
Members
409,863
Latest member
stacy09
Top