Although I didn't think this was going to work, it did perfectly. However,
when I copied the formula to another cell and changed the return column to
return a different value, it returns the false option instead. I checked the
formula 3 times. Any ideas? Here are the two formulas, the first one
worked, the second one did not.

=IF(AND(Sheet1!$I$13=FreightFactors!$B$3:$B$102,S heet1!$I$13<=FreightFactors!$C$3:$C$102),FreightFa ctors!$A$3:$A$102,"")

=IF(AND(Sheet1!$I$13=FreightFactors!$B$3:$B$102,S heet1!$I$13<=FreightFactors!$C$3:$C$102),FreightFa ctors!E3:E102,"")

The only difference is the value_if_true has changed to a different column.

"JLGWhiz" wrote:

You could test if column A is less than 20 And column B is greater than
twenty, if true D = C.

=IF(AND(A1<20,B120),C1,"")

Put in col D and copy down


"mthead" wrote in message
...
What I need to do:

Using Value "A" (let's say 20), lookup on on a table and find the row that
20 falls in the range of column A and column B (let's say column A is 15
and
column B is 25) i want to return the value of column C in the same row.
There is a possibility of 150 different rows. Also, value A is in
workbook
Jobs, and the table is in workbork Tables.

Any expertise would be appreciated.


.