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.