I am trying to take what in Sheet1 Cell C2 and move the data to match from Sheet 2. So if I put on $132,000 it would use the column of data on Sheet Two for 100,000 - 150,000 if I put in $31,560 it would use the column of data for $30,000 to $39,999.
Here is the formula I have so far. Tell me where I messed up!
=IF($C$2>="15,000",Sheet2!D4,IF($C$2<="$30,000",Sheet2!E4,IF($C$2<="$40,000",Sheet2!F4,IF($C$2<="$50,000",Sheet2!G4,IF($C$2<="$70,000",Sheet2!H4,IF($C$2<="$100,000",Sheet2!I4,IF($C$2<="$150,000",Sheet2!J4,IF($C$2<"200,000",Sheet2!K4,Sheet2!C4))))))))
Can someone re-write the formula correctly for me?
Bookmarks