=INDEX(Sheet1!$A$1:$B$43,MATCH(I2,Sheet1!$A$1:$A$4 3,0),2)

This formula pulls a line item price for a billing code. In my master sheet
I2 is the billing code and on sheet1 column 1 is the billing code and column
2 is the price associated with that code. Column C on the master has an
installer number. I need to add sheet 1 Column 3 which will contain a second
level price for each code. I also need to make two lists on sheet 1, one for
contractor installer number and one for employee installer number. I need the
installer number from Column C on the master to compare to each of these
lists and make the determination which column to pull the price from.