T
tuph
I am using the formula below (adapted from one found on this forum
thanks!) and it works as far as it goes. However, I need to have it i
all cells in column E (it's a data series for a chart), but those field
should be left empty if no match is found in B2:B7. Any suggestions?
My formula: =INDEX($A$2:$A$7,MATCH($E3,$B$2:$B$7,0))
Sales GP% GP$ Data Series A Lookup Formula
637512.6029 22.8 145352.8735 22 #N/A
638125.1545 23.5 149959.4113 22.1 681463.3977
681463.3977 22.1 150603.4109 22.3 #N/A
513994.8321 21.3 109480.8992 22.4 #N/A
710869.19 22.6 152836.8759 22.5 #N/A
690007.02 23.2 160081.6286 22.6 710869.19
Thanks in anticipation.
Tris
thanks!) and it works as far as it goes. However, I need to have it i
all cells in column E (it's a data series for a chart), but those field
should be left empty if no match is found in B2:B7. Any suggestions?
My formula: =INDEX($A$2:$A$7,MATCH($E3,$B$2:$B$7,0))
Sales GP% GP$ Data Series A Lookup Formula
637512.6029 22.8 145352.8735 22 #N/A
638125.1545 23.5 149959.4113 22.1 681463.3977
681463.3977 22.1 150603.4109 22.3 #N/A
513994.8321 21.3 109480.8992 22.4 #N/A
710869.19 22.6 152836.8759 22.5 #N/A
690007.02 23.2 160081.6286 22.6 710869.19
Thanks in anticipation.
Tris