Can you send the sample file for reference.
Regards,
Pawan
On Tuesday, 1 December 2015 20:53:42 UTC+5:30, Alan Walsh wrote:
>
> Hi All
>
> problem description. I have an excel sheet that i update manually. I want
> to update automatically.
>
> Here is what I have, A list of faults in a column,
Hi Pawan
=VLOOKUP("*Station 18 (Vacuum)",F3:G21,2,FALSE)
It just equates to N/A, have tried the asterisk on both ends.
regards Alan
On Wed, Dec 16, 2015 at 5:11 PM, Pawan Yadav wrote:
> Hi Alan,
>
> Can you provide the formula which you are driving by using wildcard
> ("*Station 18 (Vaccum)*"
Hi Alan,
Can you provide the formula which you are driving by using wildcard
("*Station 18 (Vaccum)*") but not getting solution?
Note: Don't use Lookup function if your list not in ascending order. Use
Vlookup function with exact match by using wildcard.
Regards,
Pawan
On Tuesday, 1 December
