G
Guest
I am trying to find a lookup formula that will use TWO different variables.
One value is on the horizontal row one on the vertical of a spreadsheet. It
must then lookup on a separate sheet and return a value, providing BOTH
values have been found.
eg:
Sheet 1:
6397 6398 6536 6399 6400 6401 6403
SUINT
SUDOM
ARINT
ARDOM
AMDOM
AMINT
VVDOM
SBINT
ACINT
ASDOM
Sheet 2:
TGDOM 6398 100
HPDOM 6398 250
ASDOM 6398 80
ADINT 6398 40
ZLDOM 6398 30
CODOM 6398 60
In this above example, it must lookup the values across the top (eg:
6397,6398,6536 AND the value down the side ('SUDOM") and when it finds both
of these on the 2nd sheet, return the value in the 3rd column (eg 100,250,80a)
One value is on the horizontal row one on the vertical of a spreadsheet. It
must then lookup on a separate sheet and return a value, providing BOTH
values have been found.
eg:
Sheet 1:
6397 6398 6536 6399 6400 6401 6403
SUINT
SUDOM
ARINT
ARDOM
AMDOM
AMINT
VVDOM
SBINT
ACINT
ASDOM
Sheet 2:
TGDOM 6398 100
HPDOM 6398 250
ASDOM 6398 80
ADINT 6398 40
ZLDOM 6398 30
CODOM 6398 60
In this above example, it must lookup the values across the top (eg:
6397,6398,6536 AND the value down the side ('SUDOM") and when it finds both
of these on the 2nd sheet, return the value in the 3rd column (eg 100,250,80a)