[Excel] a vlookup sort of question

Author	All Replies
PhoenixDown -- Wants FIOS Premium join:2003-06-08 Fresh Meadows, NY kudos:1	[Excel] a vlookup sort of question So I'm trying to create a better mouse trap One one sheet, I have the following layout of information. Table # \| Tier Level \| % On the second sheet I have two tables which would be determined based on the table #. % From \| %to \| Tier 1 \| Tier 2 \| Tier 3 \| Tier 4 90% \| 100% 80% \| 90% So basically the formula would determine which table to look at, and then depending on the precentage level and tier, return the value from the x and y coordinates. I'm thinking this will be a mix of vlookup and hlookups but I am wondering if there is a more efficient formula command to use? -- 1/22/2012 Delegate Count Newt 25 \| Romney 14 \| Ron Paul 10 \| Santorum 8
	to forum · permalink · 2012-02-28 10:28:36 ·

RWild Them Or Us Premium join:2003-09-15 Cary, NC	You really need to provide more information. Looks likely that you need to use a pivot table to populate the tables in the second sheet.
	to forum · permalink · 2012-02-28 10:43:09 ·
PhoenixDown -- Wants FIOS Premium join:2003-06-08 Fresh Meadows, NY kudos:1	reply to PhoenixDown Took me a while but I was able to figure it out using the Index and Match functions in the formula, thanks
	to forum · permalink · 2012-02-28 15:28:28 ·

OS and Software > Microsoft Help > [Excel] a vlookup sort of question