**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.*