Lookup Intersection Of Values

[rflooring]

Hello Everyone!
I have been beating my head against the wall on this one for a bit, so please help! I don't consider myself a master of excel, but can get around well for basic formulas and functions. I am trying to create a table that references data in a much larger report that constantly has rows and columns added and deleted off of it. Any ideas on if this is possible or how to do it? Here is an example:


---------------Juice Sell In-----Desert Sell in-----Total Sales

James--------34%---------------8%---------------22
Frank---------22%---------------2%---------------18


This is a simple example of what I would be trying look data up from. But there are hundreds or rows and columns in the actual report, so I am creating another document that just pulls the data I need to review off of the larger report. New rows and columns are added to the report on a daily basis. So I am trying to have a cell return a value as a result of an intersection of 2 other values that remain constant. For example: Looking up the intersection of the row that contains "James" and the column that contains "Total Sales" would return "22" as the result in the cell.

Does anyone know how to do this, or if it is possible? Please help! Thanks!

[shg]

Welcome to the forum.

See http://j-walk.com/ss/excel/usertips/tip020.htm

[Tony Valko]

One way...

Data Range

	A	B	C	D
1		Juice Sell In	Desert Sell in	Total Sales
2	James	34%	8%	22
3	Frank	22%	2%	18
4
5
6	James	Total Sales	22

This formula entered in C6:

=VLOOKUP(A6,A1:D3,MATCH(B6,A1:D1,0),0)

[Armando Montes]

Check intersection operator:
http://www.myonlinetraininghub.com/e...he-lazy-lookup