Excel: Avoiding Nesting Multiple Vlookups / One Value against changing Array

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.

This question generated 11 answers. To proceed to the answers, click here.

This thread is current as of October 17, 2014.

For more resources for Microsoft Excel