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.