Data base

[hapitaron]

I am trying to pull from a database information based on information
parameters that I have in other work sheet) e.g
column department= 150,
rows GL code code =67
I tried Vlookup/ Hlookup work with just one parameter, I am looking fo
a formula that will take both in consideration in the same tim

 

[Biff]

Hi hapitaron!

If I understand you correctly, here is the basic formula:

=VLOOKUP(A1,C5:G15,MATCH(B1,C4:G4,0),0)

It returns the value found at the intersection of the
column labeled 150 and the row labeled 67.

A1 = GL code to find - 67
B1 = Department to find - 150
C5:G15 = table array
C4:G4 = Department column labels (150)

Biff

 

[Frank Kabel]

Hi
try
=INDEX(A1:X100,MATCH(67,A1:A100,0),MATCH(150,A1:X1,0))