I'm trying to input phone and fax numbers into cells based on the name of a contractor selected from a drop down box. I though I had this figured out no problem but i'm getting #Num! Error and its driving me nuts. On one sheet I have a contractor list column A, phone column B, fax column C. I'm using the formula =SMALL(IF(Contractors!A1:A5000='Bid Sheet Page 1'!$C$9,ROW(Contractors!A1:A5000),9999),ROW()-1) to show the row number on the "contractors list" sheet that corresponds with the given. For example, lets say a user selects ATZ from the drop down box. Row A on my sheet will show the row number of ATZ on the contractors list. Using that row number I will then use =IF($A2<>9999,INDEX('Contractor list'!$A$1:$H$10144,'Bid Sheet 1'!$A2,COLUMN('Bid Sheet 1'!B2)),""). I haven't got to the second part yet but I think I should be ok there. Whats the problem with my first formula? See my attached sheet.
Bookmarks