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:
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: Find cells with value.xlsx Read More