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"
For more on this see attached file:
https://1drv.ms/x/s!Ai3wejactZJ_rm-6JEjRSwJ8rk-V?e=HH69Vu
7 Replies
- 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"Or bit another setup
=SUBSTITUTE( XLOOKUP($E$6:$E$200, $E$6:$E$200, $F$6:$F$200, ""), "", "" )
