Forum Discussion
Solved
Return value based on criteria
Hi, I need a formula that will find a matching value and return a record Example E6 = "SPA" F6 = "3.23" E13 = "SPA" F13 = "3.23" The formula will go into F13 and return "3.23...
Thank you for responding
Just nearly what I am looking for. It needs a little modifying though.
Where there is nothing to return then the cell should remain empty showing neither "0" or "not found"
Just nearly what I am looking for. It needs a little modifying though.
Where there is nothing to return then the cell should remain empty showing neither "0" or "not found"
Or bit another setup
=SUBSTITUTE( XLOOKUP($E$6:$E$200, $E$6:$E$200, $F$6:$F$200, ""), "", "" )