• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VLOOKUP Function does not work

Status
Not open for further replies.
S

Sachin536

New Member
Hi,
Moderator note:
You have asked to edit below capital text ...

AS PER THE ATTACHED EXCEL SHEET, I FACING IN THIS LIKE THR OUTPUT DOES NOT RETURN PROPERLY IN V & W COL. I.E. JOB START DATE & END DATE. ( YELLOW COLOR)

PLS HELP

BELOW IS THE FILE LINL
docs.google.com

Customer Orders and Machine..xlsm

docs.google.com docs.google.com
 
Last edited:
Sachin536
Have You refer Your formulas with Vlookup's syntax?
=VLOOKUP(What you want to look up, where you want to look for it, the column number in the range containing the value to return, return an Approximate or Exact match – indicated as 1/TRUE, or 0/FALSE).
  1. The value you want to look up, also called the lookup value.
  2. Your where you want to look for it ... could it be a fixed range?
Please, edit Your #1 text as You've asked.
 
Dear sir,

Thanks for your continuous support,

I have created a report with machine types wise Machine working production hours details. In this, I will tell you in detail.

Each machine works only for 11 hours a day. That's why I have created this report using a macro so that I will know which machines (Each Machine No.) have how many days of works load.

And I created a new sheet in the same excel file for all machine no’s and also plotted a VLOOKUP formula.

But right now, this problem is coming in the report that if I select any machine no (B-008 ) and update its continuous production time/ working hour then VLOOKUP is working well and give the proper Job Start date and End date.

But once I change machine no ( B-023, B-024 & B-025 )after that again repeat the same machine no ( B-008), thereafter no values and entry shows in the V & W columns.( Job start date and end date)


This is the problem and please solve this query.

Please note, once you update any value in production time hours (U column) please click on refresh on Summary 1 sheet.

video link :

22-45-00.mp4

drive.google.com drive.google.com

docs.google.com

Customer Orders and Machine..xlsm

docs.google.com docs.google.com
 
Sachin536
You've asked to edit Your original text few times ... You've skipped.
Did You checked that my given solution? ... hmm?
There are rules - how do this Forum works as well as how do Excel work?
If You even won't try something, then I can only wish a good luck for You and take care.
 
Status
Not open for further replies.
Back
Top