Hi, I'm not a pro in excel but I do all my report for my company with it. Lately, I got in charge of generating a material report on my project. so I have a unique number for ordering material. using that number I do Vlookup on my report to read from company's material report. unfortunately, that report sucks because it records all requested and Vlookup reads the first status no matter whether it is right or wrong. let's see an example
my question is:
is there a way to tell Vlookup to look for the last request date to each WO and read its status?
I tried to use IF function but didn't work because it is repeated number? I tried to do them manually but that takes time especially when my manager is waiting for my report.
Do you guys recommend me to learn access and do it with it?
Bookmarks