Excel - How to Use a VLOOKUP Formula - Expert Solution

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

i need vlookup formula how can i use in diff sheets
Solved by B. B. in 60 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 17/09/2018 - 10:59
Welcome to excelchat, I see your question is about vlookup formula.
Excelchat Expert 17/09/2018 - 10:59
I can help you with the problem. I'll also provide a full explanation of the solution.
Excelchat Expert 17/09/2018 - 11:00
Before we get started, this is a reminder that our policy is 1 problem per session with additional Q&A on that problem as time allows.
User 17/09/2018 - 11:00
sir me how to match 2 sheet 2 column by vlookup formula so please help me
Excelchat Expert 17/09/2018 - 11:00
Let me ask you a couple of quick questions to make sure I fully understand your problem.
Excelchat Expert 17/09/2018 - 11:00
I need to see a few sample data.
Excelchat Expert 17/09/2018 - 11:01
Can you please show me your file?
User 17/09/2018 - 11:01
sir i how to showing you sample data please tell me
User 17/09/2018 - 11:02
[Uploaded an Excel file]
Excelchat Expert 17/09/2018 - 11:02
You can either write on the preview window on the right hand side or you can click on the paperclip icon to upload a file here.
Excelchat Expert 17/09/2018 - 11:02
Thank you, I see the file you sent.
User 17/09/2018 - 11:02
u get this sheet??
Excelchat Expert 17/09/2018 - 11:03
Yeah, I have it.
Excelchat Expert 17/09/2018 - 11:03
Now which two columns you want to match?
User 17/09/2018 - 11:03
okay so please u check the opening 2017-18 sheet and last column
Excelchat Expert 17/09/2018 - 11:04
You mean column G?
User 17/09/2018 - 11:04
no column A and row no. 3701
User 17/09/2018 - 11:05
Matches Box qty is 5785 this one where its in sheet closing 2017 Stock Summary
User 17/09/2018 - 11:06
if this qty in closing 2017 Stock Summary and sheet opening 2017-18 so i how to find and pick from that sheet new sheet
User 17/09/2018 - 11:07
are u understand sir ?
Excelchat Expert 17/09/2018 - 11:07
So, you are saying you want to match cell A3701 in both sheets?
User 17/09/2018 - 11:08
yes sir
User 17/09/2018 - 11:08
where its qty like same in both sheet
Excelchat Expert 17/09/2018 - 11:09
Sorry, can you please say that again?
User 17/09/2018 - 11:11
please see the right side in sheet i explain u
Excelchat Expert 17/09/2018 - 11:11
Thank you, I'm looking at it.
User 17/09/2018 - 11:13
that to qty is match but item name is diff so i wich formula using than they will be come here new sheet seapratly
Excelchat Expert 17/09/2018 - 11:13
Can you show me an example also?
Excelchat Expert 17/09/2018 - 11:13
What you need in the new sheet.
User 17/09/2018 - 11:14
same qty with item name
Excelchat Expert 17/09/2018 - 11:15
You don't need to write a formula, please just show me what you need manually.
Excelchat Expert 17/09/2018 - 11:15
Just a reminder, you need to select YES to extend time. You will be asked shortly.
User 17/09/2018 - 11:17
sir where its qty is 5785 in sheet1 and like same qty where its sheet2 if same qty match so me need in new sheet
User 17/09/2018 - 11:19
in new sheet we using formula so in that formula with me need name of item and qty 2 column
Excelchat Expert 17/09/2018 - 11:19
I understand that you are saying if the quantities matches in both sheets, then you need something. But I'm not sure what is it you need. So, if you can show me the result in new sheet, it will be helpful.
Excelchat Expert 17/09/2018 - 11:20
Okay, let me try something..
Excelchat Expert 17/09/2018 - 11:21
Please look at H18 and I18 of Sheet2.
User 17/09/2018 - 11:21
ok
Excelchat Expert 17/09/2018 - 11:21
Is that what you need?
User 17/09/2018 - 11:21
ok
User 17/09/2018 - 11:22
yes sir this one
User 17/09/2018 - 11:23
H18 u copy and pest right ?
Excelchat Expert 17/09/2018 - 11:23
Yeah, I did in manually.
Excelchat Expert 17/09/2018 - 11:24
Just to make sure, You need the item names from closing 2017 Stock Summary sheet in opening 2017-18 sheet if the amounts are the same but names are not same.
Excelchat Expert 17/09/2018 - 11:24
Do you believe that will address your problem?
User 17/09/2018 - 11:25
yes sir name is not same that one problem sir
Excelchat Expert 17/09/2018 - 11:26
Okay, Please give me 10-15 minutes.
Excelchat Expert 17/09/2018 - 11:26
You need to extend time again if you are asked.
User 17/09/2018 - 11:26
but sir session was expire than
User 17/09/2018 - 11:27
okay me asking yes and no right ?
Excelchat Expert 17/09/2018 - 11:27
Yeah that's right.
User 17/09/2018 - 11:27
okay sir i will wait for as
Excelchat Expert 17/09/2018 - 11:34
Sorry, I was able to write a formula but it won't give you correct results. Because There are many many cases where you have the same amount in column B but the names are different in column A.
User 17/09/2018 - 11:35
okay sir not a problem but amount and qty are possible
User 17/09/2018 - 11:35
item name u leave it
Excelchat Expert 17/09/2018 - 11:35
I have also done that.
Excelchat Expert 17/09/2018 - 11:36
The same. I'm sending the file now so that you can see.
User 17/09/2018 - 11:36
okay saying me please
User 17/09/2018 - 11:37
i didnt have file
Excelchat Expert 17/09/2018 - 11:37
[Uploaded an Excel file]
Excelchat Expert 17/09/2018 - 11:37
Here it is.
User 17/09/2018 - 11:38
yaaaa ok ok
Excelchat Expert 17/09/2018 - 11:38
Please check opening 2017-18 column H.
User 17/09/2018 - 11:40
where its download sir that sheet in my system
Excelchat Expert 17/09/2018 - 11:40
[Uploaded an Excel file]
Excelchat Expert 17/09/2018 - 11:41
Please hover over to excel icon to download.
Excelchat Expert 17/09/2018 - 11:41
And I have wrote a different formula and it worked.
Excelchat Expert 17/09/2018 - 11:42
Are you able to download it?
User 17/09/2018 - 11:43
nothing sir
User 17/09/2018 - 11:43
same is came
Excelchat Expert 17/09/2018 - 11:43
You are not able to download in yet?
User 17/09/2018 - 11:44
where u working in this sheet and where u using formula in this sheet sir plz tell me
Excelchat Expert 17/09/2018 - 11:44
I have sent you a excel file.
Excelchat Expert 17/09/2018 - 11:45
I was not working on the sheet.
Excelchat Expert 17/09/2018 - 11:45
Please apply this formula in your excel files column H =IF(INDEX('closing 2017 Stock Summary'!$A$11:$A$3536,MATCH(1,INDEX(('closing 2017 Stock Summary'!$B$11:$B$3536=B10)*('closing 2017 Stock Summary'!$C$11:$C$3536=C10),0,1),0))=A10,"",INDEX('closing 2017 Stock Summary'!$A$11:$A$3536,MATCH(1,INDEX(('closing 2017 Stock Summary'!$B$11:$B$3536=B10)*('closing 2017 Stock Summary'!$C$11:$C$3536=C10),0,1),0)))
User 17/09/2018 - 11:46
okay sir
User 17/09/2018 - 11:46
i have
User 17/09/2018 - 11:47
sir plz just see the sheet opening 2017-18
User 17/09/2018 - 11:47
row no. 10
Excelchat Expert 17/09/2018 - 11:47
Yeah. Seeing that now.
User 17/09/2018 - 11:48
item you matching okay
User 17/09/2018 - 11:49
but sir me need qty in next column "I"
User 17/09/2018 - 11:49
like if same in both sheet
User 17/09/2018 - 11:50
just u check plz qty is same here and there
User 17/09/2018 - 11:50
hi sir Plc
Excelchat Expert 17/09/2018 - 11:51
So you also need to see the quantity?
User 17/09/2018 - 11:51
yes sir
User 17/09/2018 - 11:51
if match in both side
Excelchat Expert 17/09/2018 - 11:51
[Uploaded an Excel file]
Excelchat Expert 17/09/2018 - 11:52
Download and see this file now.
Excelchat Expert 17/09/2018 - 11:54
Is that correct now?
User 17/09/2018 - 11:55
but corrector was not showing in the sheet
Excelchat Expert 17/09/2018 - 11:55
We can't extend again.
User 17/09/2018 - 11:55
if not match there only showing N#A
User 17/09/2018 - 11:55
Please one time Extend only
Excelchat Expert 17/09/2018 - 11:56
When the session close, please post again.
Excelchat Expert 17/09/2018 - 11:56
I will claim the question and work with you.
Excelchat Expert 17/09/2018 - 11:56
The system only allows maximum 1 hour
User 17/09/2018 - 11:56
if ower chat and solution are not finish than plz extend only
Excelchat Expert 17/09/2018 - 11:56
So, we can't extend further.
User 17/09/2018 - 11:57
okay sir i just with u chatting
Excelchat Expert 17/09/2018 - 11:57
I will try my best to solve the problem.
User 17/09/2018 - 11:57
what is your name
User 17/09/2018 - 11:58
so i how to recognize u
Excelchat Expert 17/09/2018 - 11:58
I will recognize the problem if you post with the same description.
Excelchat Expert 17/09/2018 - 11:58
And I will know it's my problem.

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.