Excel 2010
I have this problem I cannot figure out. I generally use Vlookups.
My lookup value is in cell A4, this equals $1538.00.
I want to check a dataset for this value.
The dataset =
col1
$1,538.46 $1,538.00 $1,538.47 $1,538.45 $39,999.96
Basically the value of A4 can vary up to x variations - this is in my table.
what I need:
I want to check A4 against col1, then col 2, then col 3 etc. and return col 5 when any of these cols match. if not, then 0.
I have this problem I cannot figure out. I generally use Vlookups.
My lookup value is in cell A4, this equals $1538.00.
I want to check a dataset for this value.
The dataset =
col1
$1,538.46 $1,538.00 $1,538.47 $1,538.45 $39,999.96
Basically the value of A4 can vary up to x variations - this is in my table.
what I need:
I want to check A4 against col1, then col 2, then col 3 etc. and return col 5 when any of these cols match. if not, then 0.