Z
zx6roo
I have the following individual functions
=INDEX(Sheet2!$D$3:$H$7,MATCH($F7,ONE,0),5)
=INDEX(Sheet2!$D$3:$H$7,MATCH($F7,TWO,0),5)
=INDEX(Sheet2!$D$3:$H$7,MATCH($F7,THREE,0),5)
=INDEX(Sheet2!$D$3:$H$7,MATCH($F7,FOUR,0),5)
=INDEX(Sheet2!$D$3:$H$7,MATCH($F7,FIVE,0),5)
I need to combine them all in the same cell so IF F7 matches data in ranges
ONE, TWO, ETC it will return whatever is in column 5.
I’ve done some searching on the net and also looked at Microsoft’s help on
this. I can see how to create a multiple function if I want it to be ONE &
TWO but not ONE or TWO. I’ve tried various combinations of functions but a
little stuck.
Any help is much appreciated.
=INDEX(Sheet2!$D$3:$H$7,MATCH($F7,ONE,0),5)
=INDEX(Sheet2!$D$3:$H$7,MATCH($F7,TWO,0),5)
=INDEX(Sheet2!$D$3:$H$7,MATCH($F7,THREE,0),5)
=INDEX(Sheet2!$D$3:$H$7,MATCH($F7,FOUR,0),5)
=INDEX(Sheet2!$D$3:$H$7,MATCH($F7,FIVE,0),5)
I need to combine them all in the same cell so IF F7 matches data in ranges
ONE, TWO, ETC it will return whatever is in column 5.
I’ve done some searching on the net and also looked at Microsoft’s help on
this. I can see how to create a multiple function if I want it to be ONE &
TWO but not ONE or TWO. I’ve tried various combinations of functions but a
little stuck.
Any help is much appreciated.