Multiple conditions to check and if met grab the number

[drop05]

Hi i am trying to come up with a formula where it is similar to a vlookup but there is multiple conditions to check/match

On my tab i am wanting it to find a code number, state, and type in each row going down the table; in another tab called adjustment, and the if those items match the selections then the output should be the value in column AO in the adjustment tab

Wasnt sure whats the best type of formula to do this matching/lookup

 

[awoohaw]

without example data to provide it is hard to give a formula, but, I'll use assumed range names instead of cell/range references.

but try this:

Mr excel questions 60.xlsm
	A	B	C	D	E	F	G	H	I	J
2
3	CodeNumber	State	Type				CodeNumber	State	Type	Adjustment
4	829	MD	12				829	VA	12	30%
5							931	NC	12	30%
6							197	SC	12	30%
7	lookup						202	GA	14	10%
8	10%						829	MD	12	10%
9							198	VA	12	10%
10							696	NC	13	20%
11							897	SC	13	30%
12							526	GA	14	30%
13							175	MD	13	20%
drop05

Cell Formulas
Range	Formula
A8	A8	=XLOOKUP(A4&B4&C4,CodeNumber&State&Type,Adjustment)

Named Ranges
Name	Refers To	Cells
Adjustment	=drop05!$J$4:$J$13	A8
CodeNumber	=drop05!$G$4:$G$13	A8
State	=drop05!$H$4:$H$13	A8
Type	=drop05!$I$4:$I$13	A8