Want to return a value from my pricing table into my raw data sheet given criteria in the data sheet

		Microsoft Office Forums > Microsoft Excel > Excel
Want to return a value from my pricing table into my raw data sheet given criteria in the data sheet

05-09-2016, 09:43 AM

jeffreybrown jeffreybrown is offline

Windows Vista Want to return a value from my pricing table into my raw data sheet given criteria in the data sheet

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

In G2 copied down...

Code:

=INDEX(Sheet1!$G$3:$J$7,
          MATCH($B2&$E2,Sheet1!$C$3:$C$7&Sheet1!$A$3:$A$7,0),
          MATCH($A2,Sheet1!G$1:J$1,0))

IMPORTANT

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can a Data Source be one sheet in a multi-sheet Workbook	nfotx	Mail Merge	1	07-01-2015 12:55 AM
Move data from one sheet to the next available row or cell of another sheet	bwwalker08	Excel	0	04-10-2015 11:51 AM
How to return a value in a data table using vertical and horizontal criteria	oswald	Excel	1	02-08-2015 02:01 AM
Populate sheet 3 with data from sheet 1 and sheet 2	speck	Excel Programming	0	01-14-2015 07:54 AM
Help Coloring a cell in Sheet one if data is missing from another sheet	Aeducan	Excel	1	06-22-2014 04:49 PM