Multiple vendors and scenarios - Excel

[Vincent Kelly via OfficeKB.com]

I have 1 column for 18 rows of data (data1, data 2, etc.). Each time one
of the data fields changes, it creates a different named result, and will
only ?fit? 1 result (vendor). E.g., one of the variable results has the
following type of formula:
IF(AND
(C11>=720,C6<=125000,C6>0,C5+C6<=1000000,C9<=1,C10<>"CO",C10="NR",C13<=45,C16="NOO",C15<=4,C17="N",C22="N")
,(Sheet1!A320),"No Vendor Match")
?where the cell on Sheet 1 (different Sheet), at A320 is a specific named
result, e.g., ?Vendor 23?, else ?No Vendor Match?. The formula currently
works, but only for each vendor ID (e.g., A320).
Problem: I have a couple hundred ?vendors?, all related to different
?formulas? (parameters); hence, a couple hundred ?rows? of scenarios
(formulas). However, if a scenario fits a particular ?vendor?, I want that
vendor name/number to show in a single blank cell below my 18 rows of data
input (regardless of the vendor cell reference).
Right now, the individual vendor only shows within the cell containing the
formula, hence the user never knows where in the hundred or so rows the
result will appear.

Basic data input sheet:
data 1 (0 to 100)
data 2 (A to c)
data 3 (67 to 89)
data 4 (etc.)
data 5
data 6
data 7
data 8
data 9
data 10
data 11
data 12
data 13
data 14
data 15
data 16
data 17
data 18

Vendor: _________(result)

 

[GaryDK]

Hi Vincent,

If I understand your description correctly, this frmula should do the
trick:

=INDEX(Sheet1!A:A,MATCH("Vendor *",Sheet1!A:A,0))

I hope that works,

Gary