Excel - COLUMN Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc