Vlookup Help

[amcilveen]

Hi folks,

i am trying to figure out a formula that will find a match for three different cells A,B,andC combined into one cell on another tab along with column 2 on that other tab being greater than X number

This is what i currently have but it grabs the first result it finds on Sheet2, i need to add the criteria to say column 2 on Sheet2 needs to be greater than 0.375. so on sheet2 column A is where it would find A83&E84&"AM" combined into one cell.

=IF(E84="","",(VLOOKUP($A83&E84&"AM",Sheet2!$A$1:$G$3000,2,0)))

Is this even possible?

 

[duggie33]

Please provide some example data (using the XL2BB tool) that shows what you are trying to do with the expected results.

Thanks,

Doug