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.