Excel - How to Use a VLOOKUP Formula - Expert Solution

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

hi. i need a help on vlookup formula . i need to create a excel please help me
Solved by F. W. in 27 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 30/04/2018 - 11:46
Hello
User 30/04/2018 - 11:46
hi sir
Excelchat Expert 30/04/2018 - 11:46
Welcome to got it pro.
User 30/04/2018 - 11:46
tq
Excelchat Expert 30/04/2018 - 11:46
You need help with a vlookup formula, right?
User 30/04/2018 - 11:47
yes
Excelchat Expert 30/04/2018 - 11:47
Please tell me more on what you have and what you need.
User 30/04/2018 - 11:50
i want to create a vlookup formula if once i put a dispatched no that automatically calucate the remaining no and remaining sqt and put that in sheet2
User 30/04/2018 - 11:50
u got my point
Excelchat Expert 30/04/2018 - 11:51
not yet, I'm looking into it.
User 30/04/2018 - 11:53
samething automatically come to sheet 2
Excelchat Expert 30/04/2018 - 11:54
I'm still not sure.
Excelchat Expert 30/04/2018 - 11:55
To write a vlooup, we need a search value.
Excelchat Expert 30/04/2018 - 11:56
which one is the search value here/
Excelchat Expert 30/04/2018 - 11:56
?
User 30/04/2018 - 11:56
i want to search a value is total no
Excelchat Expert 30/04/2018 - 11:56
I'm sorry that I'm still not able to understand. Can you also show me what you want in sheet2?
User 30/04/2018 - 11:56
after - with dispatched no then remaining come to next sheet
User 30/04/2018 - 11:57
this is sheet 1
User 30/04/2018 - 11:58
if i put dispatched no it autoatically come to sheet 2 like this
User 30/04/2018 - 11:58
now u got my point
Excelchat Expert 30/04/2018 - 11:59
yeah, totally.
User 30/04/2018 - 12:00
then please let me know the formula
User 30/04/2018 - 12:00
ant to hide that formula
Excelchat Expert 30/04/2018 - 12:00
I'm writing the the formula, will let you know when done.
Excelchat Expert 30/04/2018 - 12:01
Please look at sheet2 column D, E and F.
Excelchat Expert 30/04/2018 - 12:02
There is no need for vlookup or any lookup formula here.
Excelchat Expert 30/04/2018 - 12:02
Once you input a dispatch number in sheet1,
Excelchat Expert 30/04/2018 - 12:02
sheet2 will show the dispatch number and other calculations automatically.
User 30/04/2018 - 12:04
if i want sheet 2 automatically fill with all fields that sheet 1 have
Excelchat Expert 30/04/2018 - 12:05
listening..
User 30/04/2018 - 12:05
i want to hide that formula
Excelchat Expert 30/04/2018 - 12:05
I'm sorry, you want to hide the formula?
User 30/04/2018 - 12:06
s
Excelchat Expert 30/04/2018 - 12:06
and you are using excel?
User 30/04/2018 - 12:06
s
Excelchat Expert 30/04/2018 - 12:07
I'm sorry isn't that a separate problem than the first problem?
Excelchat Expert 30/04/2018 - 12:08
Its our company policy that only one question per session.
User 30/04/2018 - 12:08
i want sheet 2 automatically fill with all fields that sheet 1 have
Excelchat Expert 30/04/2018 - 12:09
alright.
Excelchat Expert 30/04/2018 - 12:10
Please look at sheet2 now.
User 30/04/2018 - 12:11
thank you
User 30/04/2018 - 12:11
or i have one file
Excelchat Expert 30/04/2018 - 12:11
Glad to be able to help. I will send the file now.
User 30/04/2018 - 12:11
an i upload and tell tou what i want
Excelchat Expert 30/04/2018 - 12:11
[Uploaded an Excel file]
Excelchat Expert 30/04/2018 - 12:12
I'm sorry, this is not what you wanted?
Excelchat Expert 30/04/2018 - 12:12
Send me the file please.
User 30/04/2018 - 12:13
thats ok. i got the formula. i will put it.
User 30/04/2018 - 12:13
k you
User 30/04/2018 - 12:13
tq
Excelchat Expert 30/04/2018 - 12:13
thank you too for your patience.

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.