I have workbook number 1 with a a horizontal list of customers in row 1 and their corresponding bids in row at the bottom of the table.
I have workbook number 2 that I want to link to workbook number 1.
Workbook number 2 has a vertical list of vertical customers in column A (customers are coming from links to workbook 1, top row of customer names) and a corresponding vertical list of bids in column B (bids are coming form a link to workbook number 1, bottom row with bid numbers).
What is the formula to return the lowest bid number (MIN) in workbook 1 row of bidders at the bottom of the table, to a cell in workbook number 2? Or the lowest bid from the column B list of bids in workbook number 2?
Thanks for your input!
