G
goss
Hi ng.
Using xl xp pro
Trying to setup some lookup formulas on summary!
Data to be queried is on data!
Data is setup in this format:
Col A - Unit (15 but may need to add more)
Row 1 - Account (20 but may need to add more)
Current range defined as My_Range
Summary is setup in this format:
$d$1:$R$1 - Unit
$B$2:$B$32 - Account
Units and accounts are always text format. Ex Unit = Arizona , Account =
Phoenix A Unit may have many different accounts
Trying to setup fomula on summary! so when find matching criteria D1 and B2
return intersecting value from Data!
Then when drag formula right or down update criteria for new intersecting
values.
tia,
goss
Using xl xp pro
Trying to setup some lookup formulas on summary!
Data to be queried is on data!
Data is setup in this format:
Col A - Unit (15 but may need to add more)
Row 1 - Account (20 but may need to add more)
Current range defined as My_Range
Summary is setup in this format:
$d$1:$R$1 - Unit
$B$2:$B$32 - Account
Units and accounts are always text format. Ex Unit = Arizona , Account =
Phoenix A Unit may have many different accounts
Trying to setup fomula on summary! so when find matching criteria D1 and B2
return intersecting value from Data!
Then when drag formula right or down update criteria for new intersecting
values.
tia,
goss