Share via

How to create an Excel function that will transfer data from column in O if criteria in column Q is met?

Anonymous
2023-09-02T22:51:18+00:00

I'm trying to make it so that I have an equation in Row N that will search Row O for the word "Venmo", and if so return the value in column R that is adjacent to it. Any advice?

Microsoft 365 and Office | Excel | Other | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Bob Jones AKA CyberTaz MVP 436K Reputation points
2023-09-03T00:48:03+00:00

Advice? Yes... Rethink your plan 🙂. Excel functions cannot send results to other cells. What they can do is look up & return information from other cells to be displayed in the cell containing the formula. if that will suffice the solution is rather simple. Assuming the data records begin in cell O2 use the formula =IF(O2="venmo",R2,"") then copy down as far as necessary.

Was this answer helpful?

2 people found this answer helpful.
0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest