**Question description:**

*This user has given permission to use the problem statement for this
blog.*

i need to compare numbers in 2 columns 400+ lines and have it report either 'in' or 'out' based on the outcome of the comparison of the two formulas.
one is a signed out column abd the other is the products that are returned

Solved by G. L. in 11 mins

This is the chat thread from the real Excelchat help session. It contains no private user
information.

Excelchat Expert
29/05/2018 - 04:15

Hi

User
29/05/2018 - 04:15

hello

Excelchat Expert
29/05/2018 - 04:15

Welcome to Got it Pro

Excelchat Expert
29/05/2018 - 04:15

Please tell me more about the requirement so that i can help better

User
29/05/2018 - 04:16

i need to compare two columns and have it return an in or out in a 3rd column

Excelchat Expert
29/05/2018 - 04:16

Can you paste the sample data

Excelchat Expert
29/05/2018 - 04:17

and tell the logic behind so that i can build the formula

User
29/05/2018 - 04:18

to track the monitros we have signed out to the ones returned and using the signed in column to tell me if its in or out

User
29/05/2018 - 04:18

A is my monitors ive signed out

User
29/05/2018 - 04:18

J is the ones that have been returned

Excelchat Expert
29/05/2018 - 04:18

what value do you want to return?

Excelchat Expert
29/05/2018 - 04:18

why 47 becomes 87?

User
29/05/2018 - 04:18

f is my final output

Excelchat Expert
29/05/2018 - 04:19

What would be the logic to generate formula for F?

User
29/05/2018 - 04:19

the j is just a sampl of the daily returns i have over 1000 outs and ins through the da

Excelchat Expert
29/05/2018 - 04:19

Tell me the logic so that i can build the formula

Excelchat Expert
29/05/2018 - 04:19

ok

User
29/05/2018 - 04:20

so i know if the one mpnitor had been returned

User
29/05/2018 - 04:20

it could be on like 3 or line 450

User
29/05/2018 - 04:20

needs to check the whole column and return the in or out

Excelchat Expert
29/05/2018 - 04:21

See column F

Excelchat Expert
29/05/2018 - 04:21

i have used vlookup to generate which are returned

Excelchat Expert
29/05/2018 - 04:21

matching values are populated in F

Excelchat Expert
29/05/2018 - 04:21

Do you see it?

User
29/05/2018 - 04:21

yes

Excelchat Expert
29/05/2018 - 04:22

Do you want me to in column F - Returned or not Returned?

Excelchat Expert
29/05/2018 - 04:22

See now

User
29/05/2018 - 04:22

its designed to turn white with conditional format once in is types into the cell

User
29/05/2018 - 04:23

that does work

Excelchat Expert
29/05/2018 - 04:23

Cool

Excelchat Expert
29/05/2018 - 04:23

See column F..hope this helps

User
29/05/2018 - 04:23

possible to not show the numbers and have it read as returned?

Excelchat Expert
29/05/2018 - 04:23

Yes i can do it..let me build

User
29/05/2018 - 04:24

awesome ive been fighing this for an hour, my ecal skills have disapeardover the years of not using it

Excelchat Expert
29/05/2018 - 04:24

See now

Excelchat Expert
29/05/2018 - 04:24

Hope this helps

User
29/05/2018 - 04:24

yea that perfect :D

Excelchat Expert
29/05/2018 - 04:25

Please do give good rating and reviews

Excelchat Expert
29/05/2018 - 04:25

It really helps

User
29/05/2018 - 04:25

oh i will you saves me tons of time

Excelchat Expert
29/05/2018 - 04:25

Thanks

Excelchat Expert
29/05/2018 - 04:26

You can provide your rating when you end the session

User
29/05/2018 - 04:26

ok thanks

Excelchat Expert
29/05/2018 - 04:26

welcome

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user
information.*