In my example booklet. I've got two sheets.
Sheet 1 has 9 inputs (rows) from 5 sources: A,B,C,D,E (columns)
Sheet 1 also has flag columns to match inputs based upon similiar values (names) in description columns.
Sheet 2 - has two tables,
first table matches values of different sources w/ similiar descriptions
onto the same row.
table two: displays, min. value for each row in first table.
In the last column (P) of table 2, I'd like to have the descriptions (from sheet1) for the min value being displayed in the table(sheet2), Values for the Descriptions will come from one of these columns, C,L,U,AD,AM , depending
on min value from either columns E,N,W,AF,AO on sheet1 or min value
being display in table 1 or 2 on sheet 2. I don't know what information
is easier to reference.
The two conditions to consider would be: the value in the flags column for the source with the lowest value (from sheet1) ,is display on the row where the equivalent flag value is found on Sheet2 ,columnA
and description of the item with min value be >0.
I think a formula would have to incorporate both match and If functions.
How, I don't know.
Can anyone help me with a formula that will do this?
tia,
bdb
Bookmarks