Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I NEED A FORMULA TO COMPARE BETWEEN TWO SHEETS AND IF THE VALUE TRUE RETURN A PARTICULAR VALUE
Solved by Z. H. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 02/04/2018 - 01:42
Hi
Excelchat Expert 02/04/2018 - 01:42
Welcome to Got it Pro
User 02/04/2018 - 01:42
Hello
Excelchat Expert 02/04/2018 - 01:42
Do you have some sample data so that i can help you out?
User 02/04/2018 - 01:42
I Would like to compare two different excel sheets
User 02/04/2018 - 01:43
I would like to search for a particular column
User 02/04/2018 - 01:43
in one and if true return a value
Excelchat Expert 02/04/2018 - 01:43
yes sure..please paste some sample data on this..i will help with the formula
User 02/04/2018 - 01:44
don't understand to use this
Excelchat Expert 02/04/2018 - 01:44
i mean put some sample data from your excel..or you can attach your excel
Excelchat Expert 02/04/2018 - 01:46
have a look at the sample that i have created here
Excelchat Expert 02/04/2018 - 01:47
sheet 2 has some data
Excelchat Expert 02/04/2018 - 01:47
in sheet 1 i want to get values against column A from sheet 2
Excelchat Expert 02/04/2018 - 01:47
i have used a vlookup to get that
Excelchat Expert 02/04/2018 - 01:47
does this help you out?
Excelchat Expert 02/04/2018 - 01:47
let me know
Excelchat Expert 02/04/2018 - 01:47
=VLOOKUP(A1,Sheet2!$A$1:$B$9,2,0)
Excelchat Expert 02/04/2018 - 01:48
this is what we can use
Excelchat Expert 02/04/2018 - 01:48
hey..are you there?

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.