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