Two dimensional table lookup with 2nd dimension occurring in Row found in first dimension

		Microsoft Office Forums > Microsoft Excel > Excel
Two dimensional table lookup with 2nd dimension occurring in Row found in first dimension

FAQ

Thread Tools

Display Modes

12-03-2015, 07:59 AM

Pecoflyer

Windows 7 64bit Two dimensional table lookup with 2nd dimension occurring in Row found in first dimension

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,920

Pecoflyer has a reputation beyond repute

The attached seems to work , although I think it could be made simpler.

It uses array formulas to be committed with Ctrl+Shift+Enter

Attached Files

Copy of Example.xlsx (16.1 KB, 10 views)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How To Maintain Fixed Dimension When Inserting Photo?	bruintriton	Word	15	08-31-2015 07:10 PM
Lookup table in word	ElfegoBaca	Word	1	10-15-2014 06:34 PM
Sorting algorithm for two dimensional array	NobodysPerfect	Word VBA	1	04-07-2014 03:58 PM
Slide dimension	Fallen	PowerPoint	2	02-01-2013 01:49 PM
Dimension Autoshapes	karthikcoep	Word	0	01-16-2009 07:42 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:33 AM.