If you look at the attached spread sheet i need to make a formula that will look at 1 column for a number and return the 1st column value to the right and the 2nd column value to the right. or just the first one and i can figure out how to make it return the 2nd column.
So far i did this on my main excel book which i didnt upload. i uploaded a simpler version.
=IF(ISERROR(INDEX($A$3:$B$788,SMALL(IF($A$3:$A$788=$K$2, ROW($A$3:$A$788)),ROW(1:1)),2)),"",INDEX($A$3:$B$788,SMALL(IF($A$3:$A$788=$K$2, ROW($A$3:$A$788)),ROW(1:1)),2))
But it screws up some times by returning values that are not part of my original number "K2" i am looking up.
Bookmarks